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

Unlock this course with a free trial

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

Challenge: Create a nested XLOOKUP

Challenge: 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

Challenge: Create a nested XLOOKUP

“

(bright music) - [Instructor] In the last challenge, we went over how to perform an XLOOKUP function in either a horizontal or vertical fashion. In this challenge, we'll expand on the flexibility of our XLOOKUP function by specifying both a row as well as a column in one XLOOKUP function to return the value that we want. Here we have our profit and loss once again. This time with inputs for both our metric as well as period. Our goal is to return the value that intersects with both over here. Good luck and see you in the next video where we'll cover the solution.

Contents