From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Write a formula for a two-way lookup

Write a formula for a two-way lookup - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Write a formula for a two-way lookup

“

- [Instructor] Now this is hot stuff. Writing a Two-way Lookup really shows some Excel sophistication. So if you get this, you are really hot stuff. Here's the deal, we have packages and styles and these packages can be whatever you want to make. They can be arts and crafts, packages or books, packages, whatever. In the first row of our form, we've got Espresso Basic+. We need to retrieve the correct price from the right side, the intersection of Basic+ and Espresso, $50. We need that in cell E4, multiply it by three. get the $150, have it show up in the grand total, so please, that's the assignment. Get the prices, make the totals and generate the grand total. Pause the video, come back and you can see me do it. Okay, you ready, here we go. We need to retrieve the price, and I'm going to use XLOOKUP, equals XLOOKUP. Lookup what, I am going to lookup C4, look for C4 where? Here and a need F4 the absolute cell reference, F4, comma return what? we're going to need another XLOOKUP, open…

Contents