Xlookup In Excel: Explained In 3 Minutes
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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: • New Xlookup Function: A Vlookup Compa...
Blog post on XLOOKUP: https://www.excelcampus.com/functions...
VLOOKUP Tutorial: • Excel Vlookup Tutorial - Everything Y...
VLOOKUP Assistant Preview: • Excel Vlookup Assistant - Watch A Pre...
Please leave a comment below with any questions or suggestions. Thank you! 🙂
#ExcelCampus #MsExcel
00:00 Introduction
00:50 XLOOKUP
01:58 Search Order
Watch video Xlookup In Excel: Explained In 3 Minutes online without registration, duration hours minute second in high quality. This video was added by user Excel Campus - Jon 10 September 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 934,818 once and liked it 5 thousand people.