exact match (FALSE or 0): If there’s no exact match, return an error.close match (TRUE, 1, or omitted): If there’s no exact match, select the column with the largest top-row value that is less than the search value.
The leftmost column in the range is column 1. range is a reference to a single range of cells, which may contain values of any type. VLOOKUP ( search-for, columns-range, return-column, close-match) The VLOOKUP function returns a value from a range of columns by using the left column of values to pick a row and a column number to pick a column in that row.
Here are the details for VLOOKUP in Numbers.
