MVP! Thanks for a concise video that explains clearly!
@SheetsHelpАй бұрын
Thanks, glad you liked it!
@iamjamientu8 ай бұрын
your video is clear and simple, nice !
@SheetsHelp8 ай бұрын
Thanks! I'm glad you like it.
@LilRack Жыл бұрын
Thank you so much! You saved my day.
@SheetsHelp Жыл бұрын
Alright, glad to hear it!
@shelterpartner22 күн бұрын
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?
@SheetsHelp21 күн бұрын
Hey there, thanks for the question. It can't be done the way you described it. If you can, try using the not found message as described here: sheetshelp.com/xlookup/#Example_2_8211_Using_a_Not-Found_Message
@varunl69487 ай бұрын
This was Helpful.Thanks!
@SheetsHelp7 ай бұрын
You're welcome. I'm glad you enjoyed it.
@donchik73093 ай бұрын
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?
@SheetsHelp3 ай бұрын
Consider using the FILTER function instead. I made a video about comparing the two on my Prolific Oaktree channel. See if this helps: kzbin.info/www/bejne/sHfSantmitxnn5o
@vyasadithyaseetharaman812 жыл бұрын
hi I am not able to access this function in my google sheets.. do I need to do some update or something
@SheetsHelp2 жыл бұрын
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.
@PoshByDefault4 ай бұрын
What if I want to compare two lists and only return mutually INCLUSIVE results. So only data that appears in both lists/columns
@SheetsHelp4 ай бұрын
This may help, not sure: kzbin.info/www/bejne/h3PYfnhri9elnq8
@TechnoEveryday2 жыл бұрын
Very nice and powerful function
@SheetsHelp2 жыл бұрын
Agreed! It's much better than VLOOKUP.
@h8leech5567 ай бұрын
Thank you very much sir
@SheetsHelp7 ай бұрын
Most welcome
@guselir2 жыл бұрын
Do you happen to know what happened to XLOOKUP in Sheets ? It showed for a few days and then it went away?