Excel XLOOKUP: Learn it in 5 minutes!

RPT_7
RPT_7
35
0
Published 2022-05-26
Excel XLOOKUP is the ultimate all-in-one function that replaces all the Other Lookup Formulas (Like VLookup and HLookup). You can now search for values and bring across data from multiple tables and worksheets, leveraging the same principle used in the other Lookup. Ultimately, you won't see the annoying #N/A error appearing anymore as XLookup allows you to define a specific value to be returned in case of errors.

Chapters:
00:00 Intro
01:05 Defining the Lookup_Value - What to Lookup
01:56 Defining the Lookup_Array - Where to Lookup
02:19 Defining the Return_Array - What to Return if Lookup Matches
02:38 Defining the If_not_Found Value - What to Return if Lookup doesn't Match
02:55 Defining the Match Mode - Defining the Match Type
03:03 Xlookup First Result
03:22 Common Mistake - Locking the cells with $
04:23 Final Results

If you like the video, please don't forget to subscribe and click the notification bell!
All Comments (1)