From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Solution: Create a basic XLOOKUP

Solution: Create a basic XLOOKUP - Microsoft Excel Tutorial

From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Start my 1-month free trial Buy for my team

Solution: Create a basic XLOOKUP

“

(upbeat music) - [Instructor] Okay, how did you do? Don't worry if you struggled, because we're going to go through the answer together now. So in our first example, I have my metric to toggle, over here. I'm going to select the Cost of Goods Sold. In this case, I want to pull this value for March, 2024. So I'll select this cell, and I'll hit =xlookup, open parentheses, I'll specify my lookup value, which is cost of good sold in this cell over here. I'll then hit comma, and then I'll specify the lookup range as such. I'll then hit comma once more. And now the only thing left for me to populate is the return array. I'll select the column for March, 2024. I'll close my parentheses and I'll hit enter. And as you can see, our value for cost of goods sold for March, 2024 was populated. Great, now let's try this the other way. Here, I want to specify the date and get the corresponding value for my gross profit. So I'll select the date as my lookup value, and then I'll begin typing in my…

Contents