Excel Function

VLOOKUP

Looks up a value in the first column and returns matching value.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Arguments

lookup_value

Required

Enter the value you want to look up.

table_array

Required

Specify the full table range used for lookup.

col_index_num

Required

Enter the return column number in table_array (1-based).

range_lookup

Optional

Set lookup behavior. FALSE = exact match, TRUE/omitted = approximate match (lookup range must be sorted ascending).

Practice Preview

show matching details from a product ID. Use VLOOKUP to Looks up a value in the first column and returns matching value. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. For lookup_value, enter the value to search and set the related reference ranges. use 3 for col_index_num, use FALSE for range_lookup. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=VLOOKUP(B2, B2:D8, 3, FALSE)

Practice This Function

Practice in Sequential Mode Back to Function List