In this 10-min tutorial, we learn about XLOOKUP function in Microsoft Excel. XLOOKUP function in Microsoft Excel is versatile formula that searches an array or a range to find and retrieve data. It is more efficient and flexible compared to previous lookup functions. Let’s see How XLOOKUP function works in Microsoft Excel. Four practical examples have been provided to master in XLOOKUP function.