|
|
Featured Tutorial
Featured Macro
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
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