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.