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 nested XLOOKUP

Solution: Create a nested 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 nested XLOOKUP

“

(upbeat music) - [Instructor] Okay, let's cover the solution for our challenge on finding a value with both a column and row input using XLOOKUP. I'll start by typing in my XLOOKUP function. Here, I'll specify my first lookup, the metric that I want. I'll then reference the accounts column for my lookup range. For my return range, we now want to dynamically get a whole column's worth of data based off of whatever date I set. So to do that, I'll create another XLOOKUP function. My lookup value will be the month that I have selected over here. My lookup array will be where my months are shown, as such. And for my return array, I'm going to select our entire table. I'll then close my second XLOOKUP, followed by closing my first XLOOKUP, and I'll hit Enter and look at that. You can see that my XLOOKUP function has populated the value for Gross Profit and April, 2024. I can now change this metric to any other metric that I want, as well as any other period that I want, and my value…

Contents