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
Watch video How to use the LOOKUP function in Google Sheets online without registration, duration hours minute second in high quality. This video was added by user Sheetgo 22 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 407 once and liked it 9 people.