LOOKUP function

Description

This LOOKUP function perform an approximation match lookup in one column or one row range and returns the corresponding value from another one column or one row range. LOOKUP's default behaviour makes it useful for solving certain problem in excel.

​

Objective

Perform look up a value in a one column range.

​

Syntax

=LOOKUP(lookup_value,lookup_vector,[result_vector])

​

Arguements

lookup_value - Value to search for.

lookup_vector - One row, or one column range to search.

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

​

​