Highline Excel Class 07: VLOOKUP function formula 7 Examples

Learn about:
1)VLOOKUP to lookup an exact match
2)VLOOKUP to lookup an approximate match
3)VLOOKUP can return a value to a cell
4)VLOOKUP can return a value to a formula
5)VLOOKUP can lookup values on a different sheet (Name table and use name in VLOOKUP function)
6)Use VLOOKUP to return values from column 2 of the lookup table
7)Use VLOOKUP to return values from column 3 of the lookup table
8)Use VLOOKUP and COLUMNS function together for lookup tables with more than 2 columns

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Duration : 0:24:39

Technorati Tags: approximate, College, COLUMNS, Community, exact, excel, formula, function, Gel, Girvin, Highline, match, Mike, vlookup

Related posts:

1. Highline Excel Class 41: HLOOKUP ROWS Horizontal Lookup
2. Excel Lookup Series #2: VLOOKUP Function 2nd Example
3. Excel Lookup Series #1: VLOOKUP Function 1st Example
4. Excel Magic Trick 167p1 IF function formula: 12 Examples!
5. Excel Lookup Series #6: HLOOKUP Function