Be sure to also check this great video on Vlookup:
This video introduces and advances a very useful and practical example for the Hlookup function.
Duration : 0:14:28
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
Duration : 0:14:54