How to use XLOOKUP in Google Sheets

XLOOKUP lets you look up values and returns them with a simple, flexible formula.

Timestamps:
0:00 Intro
0:15 Simple XLOOKUP
1:37 Using a Not-Found Message
2:36 Returning Multiple Columns
3:55 Inexact Matches
5:06 Changing the Search Order
5:49 Next Video - Generate a Column of Random Numbers

#googlesheets #xlookup #spreadsheet

[shelterpartner]

Hello! Is there a way for the cell containing the xlookup formula to remain editable if no match is found? For instance, I have set up my spreadsheet so that xlookup fills in a corresponding price if a certain item is selected from the drop-down. However, sometimes a "one-off" item is entered which I've allowed as an "invalid" entry. Is it possible to edit the "price" cell as one would normally instead of being blocked by an error message in these unique cases?

[PoshByDefault]

What if I want to compare two lists and only return mutually INCLUSIVE results. So only data that appears in both lists/columns

[vyasadithyaseetharaman]

hi I am not able to access this function in my google sheets.. do I need to do some update or something

[donchik]

can I somehow use two values for the key?
For example:
I have a table like in your example at 2:36, but I have two different people named Jim, one from South and one from North. I want to lookup for both their specialities by entering the name and region. How can I accomplish this?

[miketrevor]

MVP! Thanks for a concise video that explains clearly!

[guselir]

Do you happen to know what happened to XLOOKUP in Sheets
? It showed for a few days and then it went away?

[iamjamientu]

your video is clear and simple, nice !