From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Nesting lookup functions

Nesting lookup functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Nesting lookup functions

“

- In this worksheet called NestedVlookup, we might need to use the VLOOKUP function twice. If I scroll to the right here and recognize that we have two separate tables here, and off to the left we've got some data for people's gross pay, dependents, state... And, one of the tax tables is dependent upon Dependents. We see that over here. But notice also these vary by region, so the first order of business is, based on the state entries that we see in column F, let's figure out which region each state is in. So, we'll use the VLOOKUP function here and look at the table in columns J and K. VLOOKUP: this has to be an exact match. We're looking up the word Florida and the list is in columns J and K. There's nothing else in columns J and K except the state names and the region code to the right. The answers will come out of the second column of the table. That's a 2. It must be an exact match, comma 0 or FALSE. And if this is correct, Florida, as we see it in the list over in column J…

Contents