Excel LOOKUP Function

Excel LOOKUP Function

Summary 

The Excel LOOKUPfunction performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP's default behavior makes it useful for solving certain problems in Excel.

Purpose 

Look up a value in a one-column range

Return value 

A value in the result vector.

Syntax 

=LOOKUP (lookup_value, lookup_vector, [result_vector])

Arguments 

·         lookup_value - The value to search for.

·         lookup_vector - The one-row, or one-column range to search.

·         result_vector - [optional] The one-row, or one-column range of results.

.