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

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• function
• formula
• exact
• approximate
• match
• COLUMNS
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[pjain23]

Hi Mike,

Your Excel videos are obviously amazing!

Will you also be doing MS Access , MS Project videos?

If not, do you know of any good resources to find the same?

Thanks!

[ExcelIsFun]

@pjain23 , I have basic videos on Windows Explorer, Word, PowerPoint, Excel, Access, Mail Merge:

youtube [dot] com/user/ExcelIsFun#grid/user/­B0DB785B9C9BE8A8

[miqbal7007]

Excellent sir,

you are doing awesome work

[ExcelIsFun]

@miqbal7007 , I am glad that you like them!

[Tote1883gas]

Many thanks, Best explanation yet subbed and added to favourites :)

[ExcelIsFun]

@Tote1883gas , I am glad that you found the video useful!

[prudhvirajreddyable]

excellent sir excellent keep it up

[fbanjok]

Hi,

you are a star!! V lookups have always made a fool of me...but no more...you did that!! thanks again

[rishahuj]

@Tote1883gas Have favorited it too!! Thanks bro for explaining it by breaking it down... this vlookup is crystal to me now...!!

[ExcelIsFun]

@jwroyer , Glad you like it!