XLOOKUP IN GOOGLE SHEETS

XLOOKUP IN GOOGLE SHEETS

=XLOOKUP(lookup_value,lookup_array,return_array)

METHOD 1: USING INDEX/MATCH

Combine the INDEX and MATCH functions in Google Sheets.

Use INDEX/MATCH in place of XLOOKUP in Google Sheets

METHOD 2:  USING VLOOKUP

Note: VLOOKUP numbers columns from left to right.

Finish off the formula with a FALSE argument to exactly match the employee name in the table.

Use VLOOKUP in place of XLOOKUP in Google Sheets

METHOD 3:  USING QUERY

Use QUERY in place of XLOOKUP in Google Sheets

METHOD 4:  USING FILTER

Fast, simple and effective!