Apple Numbers '08 - Manual (Page 288)

288 Chapter 12 Dictionary of Functions
VLOOKUP
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.
Examples
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.