«
»

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: , , , , , , , , , , , , ,

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

Tags: , , , , , , , , , , , , ,

This entry was posted on Tuesday, August 24th, 2010 at 6:49 pm and is filed under Learn Excel Formulas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply