After years of anticipation, Microsoft Excel team officially released it's XLOOKUP function in February of 2020. No longer Excel enthusiasts need to choose between VLOOKUP vs. INDEX/MATCH, or for that matter HLOOKUP function and their combinations - arguably one of the most advanced functions available now will help us look right AND left; vertically and horizontally; with a precise match by default; wild-card enabled; multi-cell retrieval, minimum vs. maximum values for approximate match, closes values; first and last listings, and so much MORE! Stick around as we walk through 11 examples you can use today.
