Search for a certain value in a spreadsheet column and return a corresponding piece of information from the row in which the searched value is found.
=VLOOKUP(search_key, range, index, [is_sorted])
- TRUE - approximate match, FALSE - exact match
- The index for VLOOKUP indicates columns to the right only. This may require you to move columns around before using VLOOKUP.
- After using VLOOKUP, you may copy and paste the data as values only to remove the formulas so you can manipulate the data again.
https://exceljet.net/articles/things-you-should-know-about-vlookup
23 things you should know about VLOOKUP
Although VLOOKUP is a pretty simple function, there is plenty that can go wrong. Quickly learn more than 20 things you should know about VLOOKUP to make your experience pleasant and profitable.
exceljet.net
https://infoinspired.com/sheets-vs-excel-formula/vlookup-formula-in-excel-and-google-sheets/
Comparison of Vlookup Formula in Excel and Google Sheets
I haven't seen any comparison of Vlookup formula in Excel and Google Sheets so far. I hope Excel, as well as Google Sheets users, can benefit from this.
infoinspired.com