Xlookup In Google Sheets

Steps to xlookup in Google Sheets

Option 1: Simple XLOOKUP

• Step 1: Select any cell where you want the result to appear.

• Step 2: Type the formula =XLOOKUP(, then click on the keyword you want to look up, select the lookup array, and the return array. (Note: You can fix the row or column references using the $ symbol as shown in the video)

• Step 3: Press Enter to see the result.

Result: The selected cell will now display the matching value from the return array based on the lookup keyword.

Tip: Use named ranges to make your XLOOKUP formulas easier to read and manage.

Option 2: Using a Not Found message

• Step 1: In the name column, select any incorrect or non-existent name.

• Step 2: In the lookup column, enter the formula:
  =XLOOKUP( then click on the keyword you want to look up, select the lookup array, the return array, and type "Value not found" as the fallback.

• Step 3: Press Enter to display either the correct result or the message Value not found.

Result: The cell will show the matching result if found, or display a custom message if no match is found.

Tip: Customize the fallback message to guide users on correcting their input.

Option 3: Return multiple columns

• Step 1: In the lookup column, enter the formula:
  =XLOOKUP( then click on the keyword you want to look up, select the lookup array, and select a multi-column return array.

• Step 2: Press Enter to see the results from multiple columns.

Result: The formula returns values from all selected columns that correspond to the matched keyword.

Tip: Use this method to pull complete records—like name, title, and department—all at once.