This meansXLOOKUPcan be used instead ofINDEX and MATCHto find values to the left in a table or range.
In the example shown, we are looking for the weight associated with Model H in row 12.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
for partial matches, and lookups in vertical or horizontal ranges….
