XLOOKUP NEW EXCEL FORMULA CAN LOOK LEFT AND DEFAULT EXACT MATCH

XLOOKUP is advance version of VLOOKUP and INDEX. The most advantage of XLOOKUP.

• XLOOKUP can look left.
•  XLOOKUP look exact match as default.
•  XLOOKUP return range instead VLOOKUP return only value.
• XLOOKUP is faster then VLOOKUP and INDEX.

Introduction XLOOKUP formula.

XLOOKUP Syntex :

XLOOKUP(Lookup_Value, Lookup_Array, Results_Array, [Match_Mode], [Search_Mode]) 

Simple XLOOKUP Example:-

In XLOOKUP, A2 is lookup value and it is common in VLOOKUP.

F3:F30 is lookup array

H3:H30 is result array

No need to add False or True at end because XLOOKUP look defaults as exact match.

XLOOKUP can look left

In the above example XLOOKUP look left from lookup value.

=XLOOKUP(A2,$F$3:$F$30,$E$3:$E$30)

A2 is lookup value
F3:F30 is lookup array
E3:E30 is result array which is left of  lookup array column.