Upload

Loading...

Highline Excel Class 07: VLOOKUP function formula 7 Examples

238,138 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Apr 1, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

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

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...