How to use XLOOKUP in Google Sheets

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

[@ConnectLoveStrong]

Thank you!!!

[@SheetsHelp]

You're welcome!

[@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.

[@samanzetali4872]

THANK YOUUU!!!!!

[@SheetsHelp]

You're welcome!!

[@h8leech556]

Thank you very much sir

[@SheetsHelp]

Most welcome

[@TechnoEveryday]

Very nice and powerful function

[@SheetsHelp]

Agreed! It's much better than VLOOKUP.

[@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: ruclips.net/video/QBuME5VrrhM/видео.html

[@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.

[@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!