Excel Basics #23: VLOOKUP function formula

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#23 Video topics:
1)VLOOKUP function formula
2)Data Validation List
3)VLOOKUP for Exact Match
4)VLOOKUP for Approximate Match
5)Lookup Product Price: Exact Match
6)Lookup Tax Amount: Approximate Match

Also see these videos:
Excel Lookup Series #1: VLOOKUP Function 1st Example
Excel Lookup Series #2: VLOOKUP Function 2nd Example

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• function
• formula
• Product
• Price
• or
• Tax
• Data
• Validation
• List
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Sherlock69Holmes]

Hi Mike ,

Got a Scenario to use Vlookup to return Multiple Values.

Please suggest or any better way to do so.

[ExcelIsFun]

@Sherlock69Holmes , I do not understand your question. Can you re-state it?

[90FT822]

thank you very much. it helped me much



[ExcelIsFun]

@90FT822 , you are welcome!

[raghunandanchoudhary]

I Have gone through the entire series of ecle basics and i am sure this will do wonders for me !!!

I beleive its time for high line class now :)

[ExcelIsFun]

@raghunandanchoudhary , Yes, Highline next!!!

[jasminefan1]

thank u for this ... video.. it realLy helped me to be ready for our exam Tommorow.. ;)



[Sherlock69Holmes]

@ExcelIsFun

Thanks for Reply.got the related video i am looking for.

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

[prabodhtirkey]

this video is awsum it helped in clearing my doubt...:-)

[ExcelIsFun]

@raghunandanchoudhary , you are welcome!

[ExcelIsFun]

@sillyjojo6 , you are welcome!