Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

VLOOKUP

Description: Looks for a value in the left most column of a table and returns a value from the column number you specify.

Syntax: VLOOKUP(Lookup_value, Table_array, Col_index_num, [Range_lookup])

If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than Lookup_value is returned.

The values in the first column of Table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value. You can put the values in ascending order by choosing Sheet > Sheet Actions > Sort > Sort Ascending.

If FALSE, VLOOKUP will only find an exact match. In this case, the values in the first column of Table_array do not need to be sorted. If there are two or more values in the first column of Table_array that match the Lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.

Remarks:

Example:

On the preceding worksheet, where the range A4:C12 is named Range:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.