From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

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

Using XLOOKUP for dynamic ranges

Using XLOOKUP for dynamic ranges - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

Using XLOOKUP for dynamic ranges

“

- [Instructor] Next, let's go through XLOOKUP, and how XLOOKUP can be used for dynamic ranges. XLOOKUP is a newer function that addresses many of the classic deficiencies of VLOOKUP and HLOOKUP. It allows you to select the range where you want to look up a value instead of the leftmost column or the topmost row, as is the case in VLOOKUP and HLOOKUP respectively. It also allows you to specify the range that you want to return, instead of the column number or the row number, as would be the case in VLOOKUP and HLOOKUP respectively. Let's take a look at how we can apply XLOOKUP in a dynamic way. I'm going to move all the way down here to row 47. I'm going to put my cursor here, so you can see what it is that I'm doing. Now I've used XLOOKUP to identify the value of Secondary Research, row 34, for January. Let's actually walk through what the syntax is telling us. XLOOKUP, lookup value, lookup array, return array, what to…

Contents