Excel Function

LOOKUP

Performs vector lookup in sorted data.

LOOKUP(lookup_value, lookup_vector, [result_vector])

Arguments

lookup_value

Required

Enter the value you want to look up.

lookup_vector

Required

Specify a reference range. You can drag or click start/end cells.

result_vector

Optional

Specify a reference range. You can drag or click start/end cells.

Practice Preview

return a value corresponding to a lookup key. Use LOOKUP to Performs vector lookup in sorted data. 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. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=LOOKUP(B2, B2:B8, D2:D8)

Practice This Function

Practice in Sequential Mode Back to Function List