Excel Forum
Similar Content
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
Macro: This Excel Macro works like a better Vlookup function because it returns ALL of the matchi...
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...

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.

Got a Question? Ask it Here in the Forum.