Say Goodbye to VLOOKUPs. Use XLOOKUP in Google Sheets Instead.

In the latter half of 2022 XLOOKUP was finally added to Google Sheets.
XLOOKUP returns an exact match while VLOOKUP can only return an approximate match. Learn how to use XLOOKUP effectively in this brief video.

[@DavDoesThings]

Cool tip. Thank you!

[@salehgamersa6026]

what if I want the result is to bring me all the rows of any store thats country in USA as you can see you have multible stores in USA, I couldnt solve this problem please help me

[@bernadettefernandez4049]

you can use filter

[@rocker31289]

Xlookup is the best!