What is the LOOKUP Function in MS Excel?
The LOOKUP function in Excel is a very famous function because it is sued to solve some specific problems in Excel. It works as a worksheet function in Excel.
Purpose of LOOKUP Function in Excel
The main purpose of the LOOKUP function in Excel is to lookup for a certain value in an array or range. This function gives an approximate match in the range of one column or one row.
Syntax of LOOKUP Function
The syntax of the LOOKUP function in Excel is as follows.
=LOOKUP (lookup_value, lookup_vector, [result_vector])
Arguments in the LOOKUP function are described below.
Lookup_value: the value we want to search in the array is mentioned in this argument.
Lookup_vector: in this argument, we mention the one-row or one-column range in which we want to search the lookup value.
Result_vector: this is an optional argument. The result we get from the range of one column or one row is shown in this argument.
=LOOKUP (F4, B5:B9)
According to this example, F4 is the array in which the lookup value has to be searched.
B5:B9 is the one-row or one-column range of cells where we look for the value to be returned.