From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,700 courses taught by industry experts.
Retrieve a specific value with XLOOKUP - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Retrieve a specific value with XLOOKUP
- [Instructor] XLOOKUP enables you to retrieve values based on a lookup value from the same row. The function is currently only available for Excel 2021, 2024, and Microsoft 365 users. Let's look up the state from Column E and retrieve the status from Column F. We'll look up the state from Column I. (mouse clicks) Start your XLOOKUP and open a parentheses. The lookup value is in cell I1. The lookup array is from Column E. (mouse clicks) and the return array is column F, the State. (mouse clicks) We are returning the status. The following parameters are optional. We can return an error message if nothing is found. (mouse clicks) We can specify whether or not we want to search for an exact match, and finally, how we want to search. I'll leave these last two parameters empty. I'll close the parentheses, and it retrieves my value. (mouse clicks) I can change the state, and it will update the status. Let's change the lookup column and retrieve the phone number instead. XLOOKUP has similar…
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.