How to use
XLOOKUP in Excel
If you’ve been using Excel for a while, you’ve probably come across HLOOKUP and VLOOKUP.
XLOOKUP is more flexible and far easier to use, making it a great addition to your Excel toolkit.
Why switch to XLOOKUP?
Unlike HLOOKUP (which looks up data horizontally) and VLOOKUP (which looks up data vertically), XLOOKUP can do both, making it super versatile. The syntax is straightforward, reducing the chance of errors and making your life easier. XLOOKUP also handles exact matches, approximate matches, and errors more gracefully than its predecessors.
The structure of XLOOKUP is below. click on each parameter to see an explanation
=XLOOKUP( Lookup_Value, Lookup_Array, Return_Array, If_Not_Found, Match_Mode, Search_Mode)
