From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Two-way lookups

Two-way lookups

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Two-way lookups

“

- [Narrator] Now it's time to do a two-way lookup. What is that? Let's say that I want to order the Planet7 and I want to order 33 of 'em. I need to be able to do a lookup that will do an intersection showing the Planet7 and the price that I would get for ordering 33. So I should pay 80%. That would be a 20% discount and that is the 0.8 at the intersection of Planet7 and the 20 because the 33 that I want to order it is in between 20 and 50. And at 50 and above, the Planet7 would be a 30% discount. I would pay 0.7%. Okay. Now let's kind of refresh what we know about the XLOOKUP because we have to get the price first. Okay. Here's the price equals XLOOKUP, double click. What do I want to look up? I want to look up curled axle, comma, look up array. Where do I want to look for curled axle? I'm going to highlight here. And because that data is not in a table I'm going to hit F4 for the absolute…

Contents