Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
Lookup Series 1-15
Download Excel Files:
http://excelisfun.net/files/ExcelLook...
Finished File http://excelisfun.net/files/ExcelLook...
Full Page With All File Links: http://excelisfun.net/
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.
