How to do XLOOKUP in Google Sheet using Amazing Sheet Query function
Welcome to Kimavi Videos (Landscape Mode).
How to do XLOOKUP in Google Sheet using Amazing Sheet Query function
Google sheet does not have XLOOKUP, It has even better query function
XLOOKUP in Excel helps Lookup values in a range
Let's say we have salary data with Name and Birthday
Given a name we want to find salary and birthday, we can do this easily via XLOOKUP in Excel
We can do same in Google sheet using QUERY formula
Syntax is QUERY
Here data - The range of cells to perform the query on
query - The query to perform
The value for query must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text
headers - - The number of header rows at the top of data
If omitted the value is guessed based on the content of data
Note syntax of query and how to format syntax
Play with real sheet and you will enjoy Query over XLOOKUP
Hashtags XLOOKUP, Google, Sheet, Query
....
....
Thank you from Kimavi, Please visit us at Kimavi.Com for more landscape videos
Смотрите видео How to do XLOOKUP in Google Sheet using Amazing Sheet Query function онлайн без регистрации, длительностью 01 минут 11 секунд в хорошем hd качестве. Это видео добавил пользователь Kimavi 17 Сентябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2 тысяч раз и оно понравилось 4 людям.