function for Microsoft Excel and LibreOffice Calc
Use VLOOKUP to find things in a table or a range by row. Example is finding a product price by its name.
=VLOOKUP(what to look for, data range to look up, number of column where data is, return a proximity or exact match)
VLOOKUP syntax :
what to look for the word to search for
data range to look up the data set A2:D2
number of column where data is if price is in the column D which is 4
return a proximity or exact match choose 0 or 1 : which 0 is the exact match, and 1 is proximity