Microsoft Office Tutorials and References
In Depth Information
LOOKUP (Vector Form)
LOOKUP (Vector Form)
Based on a range of one row or one column, LOOKUP (Vector Form) returns the value from the
same position in a second row or column.
=LOOKUP(lookup_value,lookup_vector,result_vector)
The LOOKUP function Vector Form looks for the value in the first vector and returns the result
from the second vector. More simply put, it looks up the value from the first range and
returns the result of the cell in the same position in the second range as shown in Figure
9.10. Notice in the timeline example, the LOOKUP function searches for the greatest value in
the range. Use this form when the value you want to look up is in the first row or column.
This is the value LOOKUP searches for in the first vector.
LOOKUP_VALUE
The range that contains only one row or column.
LOOKUP_VECTOR
The range that contains only one row or column and must be the
same as the Lookup_Vector .
RESULT_VECTOR
A
Looks up the greatest value in the range
Figure 9.10
The LOOKUP function
looks up values in one
vector (range) and
returns the result of
another vector (range).
B
Looks up a value in a range and returns the
corresponding result of another range
MATCH
MATCH returns the relative position of an item in an array that matches a specified value in a
specified order, or the position of an item.
=MATCH(lookup_value,lookup_array,match_type)
Use the MATCH function instead of the LOOKUP function when you specifically want to retrieve
the position of the item and not its value. The position of the item means if there are five
digits—1, 2 , 3, 4, 5—the position of the number 3 is three because it’s the third item in the list.
Search JabSto ::




Custom Search