VLOOKUP function

VLOOKUP uses a vertical search with reference to adjacent cells to the right.

VLOOKUP checks if a specific value is contained in the first column of an array. The function then returns the value to the same line of a specific array column named by index.


VLOOKUP(search criterion, array, index, sort order)


You want to enter the number of an item on a food menu in cell A1, and have the name of the item be displayed immediately as text in the neighboring cell (B1). The Number to Name assignment is contained in the D1:E100 array. D1 contains 100, E1 contains the name "Vegetable Soup," and so on, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional sort order argument is not necessary.

Enter the following formula in B1:

=VLOOKUP(A1, D1:E100, 2)

After you enter a number in A1, B1 shows the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number causes the text to be displayed with the next number down. If you want a nonexistent number to generate an error message instead, enter FALSE as the last argument in the formula.

Trademarks | IBM Connections wiki