Excel XLOOKUP: The Complete Guide
Excel's new XLOOKUP function is a fast, easy, versatile way to lookup data – it can do almost anything! It will completely replace VLOOKUP and HLOOKUP and for most people even INDEX & MATCH (except pro modellers). This video is the complete guide to what it can do - running through each of XLOOKUP’s functionalities, of which there are many!
Professional online courses at: https://www.claritix.co.uk/#courses
Connect on LinkedIn: / dan-stockdale
SKIP TO:
0:00 - XLOOKUP Vertical lookup (replaces VLOOKUP)
1:56 - XLOOKUP Horizontal lookup (replaces HLOOKUP)
2:37 - XLOOKUP Two-way lookup (replaces INDEX & MATCH)
5:03 - XLOOKUP If Not Found functionality
6:14 - XLOOKUP Wildcard Match Mode
7:29 - XLOOKUP Search Mode with Wildcard Match Mode
10:40 - XLOOKUP Non-Exact Match Modes
#MsExcel #XLOOKUP