In the latter half of 2022 XLOOKUP was finally added to Google Sheets.

XLOOKUP returns an exact match while VLOOKUP can only return an approximate match. Learn how to use XLOOKUP effectively in this brief video.