Excel Lookup Series #4 PART 2: 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
• IF
• IFERROR
• VLOOKUP
• functions
• in
• one
• formula
• name
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[elementoxygen]

Excellent work brother

[ExcelIsFun]

@elementoxygen , did you mean:

EXCELlent!!?

I am glad that the videos help!!

[FallahKSA]

it's fun reallly, thanks a lot

[ExcelIsFun]

@FallahKSA , you are welcome!!

[pacers3115]

great job

[ExcelIsFun]

@MrVinceb , cool! I am glad it makes sense!

[MrVinceb]

@MrVinceb Hey Mike, I get it now. I was missing what the g62 cell reference was doing. Now I see that it's referencing the vlookup column of the table (I was looking for an exact match) and . . . when it gets to the cell larger than g62, it's moving up (back)one. Took me a awhile. Thanks

[MrVinceb]

Mike, I don't get why the first vlookup was necessary. It referrenced the cell (g62 I believe) with 117,628.92, then the tax table we created, then column number 4 of the tax table. It returned 22,250 from the 4th column of the tax table. Where I get lost is . . . why the vlookup for this part of the formula? It didn't seem to work at all like a vlookup, rather just a straight cell referrence.

I've leaned a ton from your videos. This is the first thing I haven't been able to reconsile.

[xtinct2]

"UH OH, uh oh" @ 0:40 ...hahahaha

[ExcelIsFun]

I am glad that the videos help!