A newer lookup function that can search to the left and supports flexible return ranges. (Introduced in Google Sheets in 2024.)
=XLOOKUP("Item", A2:A100, C2:C100) finds "Item" in A2:A100 and returns corresponding values from C2:C100. It is more powerful than VLOOKUP/HLOOKUP.
