From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 25,600 courses taught by industry experts.
Challenge: Create a basic XLOOKUP - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Challenge: Create a basic XLOOKUP
(lively upbeat music) - [Instructor] Let's now put our knowledge to the test by creating a basic lookup function using the XLOOKUP function. We're going to do two challenges with this one. The first one will look up a value in a vertical range, while the second one will look up a value in a horizontal range. Here I have my profit and loss. In the first example, I want to look up a value for whatever metric I select for March, 2024. In the second example, I want to get my gross profit for the month for whichever value I select over here. Do you think you can do it? I.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
(Locked)
Find values flexibly with XLOOKUP6m 1s
-
(Locked)
XLOOKUP pros and cons2m 6s
-
(Locked)
How to nest with XLOOKUP4m 5s
-
(Locked)
Challenge: Create a basic XLOOKUP49s
-
(Locked)
Solution: Create a basic XLOOKUP2m 29s
-
(Locked)
Challenge: Create a nested XLOOKUP52s
-
(Locked)
Solution: Create a nested XLOOKUP1m 46s
-
(Locked)
-
-
-
-
-