How to use the LOOKUP function in Google Sheets
The Google Sheets LOOKUP function searches through a row or column for a key and returns the value of the cell in a result range located in the corresponding position to the search row or column.
Read more about the LOOKUP formula and its different usages: https://blog.sheetgo.com/google-sheet...
Like VLOOKUP and HLOOKUP, LOOKUP allows you to retrieve specific data from your spreadsheet. However, this formula has two distinct differences:
• LOOKUP formula only works if the data in the column or row is sorted.
• While VLOOKUP only searches vertically (in a column) and HLOOKUP only searches horizontally (in a row), LOOKUP formula can search both.
____________________________________________
► Visit us: https://www.sheetgo.com/
► Subscribe to Sheetgo's Youtube channel: https://youtube.com/c/Sheetgo?sub_con...
Any questions? Feel free to comment below!
#Sheetgo #Google #Sheets #functions #lookup
Смотрите видео How to use the LOOKUP function in Google Sheets онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Sheetgo 22 Июль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 407 раз и оно понравилось 9 людям.