Apple numbers User Manual

    Dictionary of Functions 

 

The VLOOKUP function retrieves a value from a range of columns by using a match 
with a left column value to choose the row and a column number to choose the 
column in that row.

VLOOKUP(search-value, cell-range, column, [exact-match])

 search-value:  The value you want to look for in the left column of the range to 

choose a row.

 cell-range:  The range of cells containing your data. The left column contains the data 

to be searched; the remaining rows contain values you can retrieve.

 column:  A number that specifies the relative column number of the cell from which 

you want to retrieve the value. The left column of the range is column 1.

 exact-match:  Optional Boolean value; determines whether an exact value is required:

TRUE, 1, or omitted selects the column with the largest top-row value that is less 
than the search value if there is no exact match.

FALSE or 0 returns an error if there is no exact match.

  

Given the following table:
  

VLOOKUP(20, B2:E6, 2) returns E.

VLOOKUP(21, B2:E6, 2) returns E.

VLOOKUP("M", C2:E6, 2) returns dolor.

VLOOKUP("blandit", D2:E6, 2) returns 5.

VLOOKUP(21, B2:E6, 2, FALSE) returns an error because no value in the left column exactly matches 21.