Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example

See 3 VLOOKUPs in 1 formula! See how to Use 3 VLOOKUPs, an IF and the IFERROR functions in 1 formula that will calculate an income tax amount. See how to name the lookup table so that creating the formula is easier.

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.

Category:

Science & Technology

Tags:

• Excel
• Multiple
• VLOOKUP
• function
• in
• one
• formula
• name
• different
• worksheet
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[kayode98]

You are awesome men. You increased my reputation and make me the go to guy on job.

[ExcelIsFun]

@kayode98 , cool! I am glad to help! Congrats on being the Go To Guy!!!

[Pilberstein1]

Also just got your book on amazon. Hope you get lots of sales...

[ExcelIsFun]

@Pilberstein1 , thank you very much for your support!!!!

[Pilberstein1]

wow. Amazing work. I don't think of ever seen a resource quite like this. Your videos are actually lot of fun to watch. For once, I believe I just might be able to master excel. You're the best!!!!!

[ExcelIsFun]

@Pilberstein1 , I am happy to hear that - i am glad that you like them!!

[tuberubering]

Hi there.

Question: Could we type "column" prior to the column number in our "tax" table array?

Thanks! :)

[ExcelIsFun]

I am glad that you like them!

[babyfcs88]

geez.. you are an expert... I just love learning it here :) great job !!

[ExcelIsFun]

Cool! Since love is the most important thing in the universe (Excel is about 3), that is a huge compliment! I am glad that you liked the video!