Excel Forum
Similar Content
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...



Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)


Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. See how to use the VLOOKUP function to look up an item in a table and return something to a cell
2. VLOOKUP with Exact Match (Lookup a word)
3. VLOOKUP with Approximate Match (Lookup a number)
4. Data Validation List (Data Ribbon tab, Data Tools Group, Data Validation) Keyboard = Alt, D, L.
5. VLOOKUP for looking up product price
6. VLOOKUP for looking up tax rate
7. VLOOKUP to assign a sales category to a sales number





Got a Question? Ask it Here in the Forum.