Friday, 16 September 2011

How to Use Excel Lookup Functions to Create a Customer Invoice

HowHowHowHow

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