Excel Lookup Series #1: VLOOKUP Function 1st Example

See how to use the VLOOKUP function to deliver a value to cell:
1) Find approximate value from column 2 of lookup table.
2) Find exact value from column 2 of lookup table.

Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate.

In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• function
• approximate
• value
• or
• exact
• column
• name
• data
• validation
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[mido1987123456]

Very good job thx alot

[ExcelIsFun]

@mido1987123456 , you are welcome!

[nimeshdhruve]

I am really glad that I found this video this explains VLOOKUP extremely well in simple English. Please keep up the good job.

[ExcelIsFun]

@nimeshdhruve , I am glad that it helps!

[romelfj]

Excellent video.. the best on you tube.. thanks a lot

[ExcelIsFun]

@romelfj , you are welcome!

[vozer2020]

Damn dude,, ;) ur FaNtAsTic0 really thx a lot that is really what I need

[ExcelIsFun]

@lozzabythway , I am glad that you like the vids!

[ExcelIsFun]

@AmyVu68 , Cool - I am glad that the videos help!

[AmyVu68]

Thank you so much for your tutorials. I have a job interview that requires me to do Vlookup and PivotTable, I am very confident I will get the job. Thank you. Keep up the great work :)