Sqikbook Business,Office VLOOKUP Function How To

VLOOKUP Function How To

VLOOKUP()

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 function

=VLOOKUP(what to look for, data range to look up, number of column where data is, return a proximity or exact match)

VLOOKUP syntax :

  1. what to look for the word to search for

  2. data range to look up the data set A2:D2

  3. number of column where data is if price is in the column D which is 4

  4. return a proximity or exact match choose 0 or 1 : which 0 is the exact match, and 1 is proximity

Related Post