Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
In this video, I give a brief overview of the new XLOOKUP function in Excel, an alternative to VLOOKUP or INDEX MATCH.
Here are some of the major features of XLOOKUP that I share in the video:
1. Only 3 Required Arguments
2. Exact Match by Default
3. Separate Lookup & Return Ranges
4. Vertical OR Horizontal Lookup
5. Partial Match with Wildcards
6. Reverse Search Order
7. Cause of # VALUE! Error
8. Availability & Compatibility
The XLOOKUP function searches for the lookup value in a column/row and returns a value from an adjacent row/column where the match is found.
It has options for exact match, closest match, and partial match with wildcard characters. It can also search in reverse order.
Additional Resources:
Full In-Depth Tutorial on XLOOKUP: youtu.be/pURSha68Mjs
Blog post on XLOOKUP: excelcampus.com/functions/xlookup-explained/
VLOOKUP Tutorial: youtu.be/d3BYVQ6xIE4
VLOOKUP Assistant Preview: youtu.be/g2_Yu_VRQ9E
Please leave a comment below with any questions or suggestions. Thank you! 🙂
#ExcelCampus #MsExcel
00:00 Introduction
00:50 XLOOKUP
01:58 Search Order
- Xlookup In Excel: Explained In 3 Minutes ( Download)
- XLOOKUP in Excel Tutorial ( Download)
- How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples) ( Download)
- How to use the XLOOKUP function in Excel ( Download)
- XLOOKUP function in #excel better than VLOOKUP ( Download)
- The Ultimate XLOOKUP Tutorial (The Best Excel Formula) ( Download)
- Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP ( Download)
- XLOOKUP in Excel | Excel Tutorials for Beginners ( Download)
- How to use VLOOKUP & XLOOKUP in excel multiple sheets ( Download)
- How to Use XLOOKUP Across Two Worksheets | XLOOKUP Examples Across Two Sheets ( Download)
- How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial ( Download)
- Ultimate XLOOKUP Guide: 10 Tips You Need to Know! ( Download)
- XLOOKUP Function in Excel ( Download)
- The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more) ( Download)
- XLOOKUP Excel Tutorial ( Download)
