Microsoft Excel Functions & Formulas

Use the VLOOKUP function to look up and

extract data from a database

This tip explains how to search for a certain product in a list. First,

take a look at the data in the following figure:

Typing a valid product number in cell B1 fills cells B2 to B4 with

the corresponding data from the list. To do this, use the VLOOKUP

function, which searches for a value in the left-hand column of a

table and returns a value in the same row from a column specified

in the table.

VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

lookup_value: The value to be found in the left-hand column of

the array.

table_array: The table in which data is looked up.

col_index_num ...