In this video, you’ll learn everything you need to know about Excel’s new and improved XLOOKUP function. Here are some of XLOOKUP's features I cover in this video:
1. How to use XLOOKUP with 5 step-by-step examples
2. How to use each argument
3. How to search for an exact match
4. How to set a default value when XLOOKUP cant find the lookup_value
5. How to search for approximate matches greater than and less than the lookup_value
6. How to search for the last instance of the lookup_value by searching from the bottom of the data
7. How to return multiple values using XLOOKUP
8. XLOOKUP’s limitations
9. How to troubleshoot XLOOKUP errors
XLOOKUP is a new lookup function that searches for a lookup_value in a row/column of data and then returns a corresponding value in another row/column. XLOOKUP had three required arguments and 3 optional arguments that determine how to search for the lookup_value and what to return if it’s not found. XLOOKUP is extremely flexible and has a lot of new search capabilities. After you watch this video, you’ll know how to use XLOOKUP to quickly find information within data.
📹WATCH EXCEL DICTIONARY'S FULL XLOOKUP VS. VLOOKUP SERIES
Part 1: How to Use VLOOKUP in Excel: • How to Use VLOOKUP in ...
Part 2: How to Use XLOOKUP in Excel: 👆🏼
Part 3: XLOOKUP vs. VLOOKUP: • VLOOKUP vs. XLOOKUP in...
📖RESOURCES
- Download this workbook and follow along: excel-dictionary.com/pages/yo...
🤓SHOP EXCEL DICTIONARY
- COURSES: excel-dictionary.com/collecti...
-GUIDES: excel-dictionary.com/collecti...
-MERCH: excel-dictionary.com/collecti...
-TEMPLATES: excel-dictionary.com/collecti...
📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: www.excel-dictionary.com/subs...
📺SUBSCRIBE
-Subscribe to never miss a video: / exceldictionary
🕰️TIMESTAMPS
‘0:00 Intro
‘0:37 XLOOKUP Overview
‘2:41 Example 1 - Exact Match Search
‘3:44 Example 2 - Return a Default Value
‘4:36 Example 3 - Search For The Last Match
‘5:29 Example 4 - Approximate Match Search
‘6:52 Example 5 - Return Multiple Values
‘7:36 XLOOKUP Limitations
‘7:51 Troubleshooting XLOOKUP Errors
‘8:06 Wrap Up
#excel #exceltips
Негізгі бет How to Use XLOOKUP in Excel (From Beginner to Advanced)
Пікірлер: 8