How to use XLOOKUP in Google Sheets

XLOOKUP lets you look up values and returns them with a simple, flexible formula.
sheetshelp.com...
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

[@LilRack]

Thank you so much! You saved my day.

[@SheetsHelp]

Alright, glad to hear it!

[@iamjamientu]

your video is clear and simple, nice !

[@SheetsHelp]

Thanks! I'm glad you like it.

[@varunl6948]

This was Helpful.Thanks!

[@SheetsHelp]

You're welcome. I'm glad you enjoyed it.

[@donchik7309]

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?

[@SheetsHelp]

Consider using the FILTER function instead. I made a video about comparing the two on my Prolific Oaktree channel. See if this helps: czcams.com/video/zFo9H0Uw4i8/video.html

[@PoshByDefault]

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

[@SheetsHelp]

This may help, not sure: czcams.com/video/QBuME5VrrhM/video.html

[@TechnoEveryday]

Very nice and powerful function

[@SheetsHelp]

Agreed! It's much better than VLOOKUP.

[@ConnectLoveStrong]

Thank you!!!

[@SheetsHelp]

You're welcome!

[@h8leech556]

Thank you very much sir

[@SheetsHelp]

Most welcome

[@vyasadithyaseetharaman81]

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

[@SheetsHelp]

The feature was released August 24 and is being rolled out over 15 days. Therefore, it makes sense that you might not have it yet. You’ll have it soon though.

[@samanzetali4872]

THANK YOUUU!!!!!

[@SheetsHelp]

You're welcome!!

[@guselir]

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

[@SheetsHelp]

I wish I knew. The same thing happened to me!