In this lesson I demonstrate how to use Three Excel Lookup Functions to create a customer invoice: The Index, Match and VLookup Functions. You will also see how to combine Excel's Data Validation "Pick List" in combination with the Index and Match Functions: Pick a vlaue from a list and watch the item number change automatically. I invite you to visit my website - TheCompanyRocks - to learn about the additional resources that I offer.
MS, Microsoft, Excel, Lookup, Functions, Index, Match, Vlookup, Arrays, Named, Cells, Ranges, Formulas, Lessons, Tutorial, How, To
Video Category: Education
No comments:
Post a Comment