In this video, I cover the best XLOOKOUP alternatives in Google Sheets. XLOOKUP is a function available in Microsoft Excel that many spreadsheet users like to use as a look up function. There is not a direct equivalent in Google Sheets, but there are some good alternatives. I show how to use FILTER, QUERY, INDEX(MATCH), and VLOOKUP.

Read through the full tutorial here:
https://www.modernschoolbus.com/xlook...

Timestamps:
00:00 Intro
1:01 What is XLOOKUP?
3:24 Lookup Using the FILTER Function
5:50 Lookup Using the QUERY Function
9:40 Lookup Using INDEX(MATCH)
10:44 Lookup Using VLOOKUP