What kind of result do you want?

MATCH returns a number that is the matched lookup_values *relative* position
in the lookup_array. You can use another formula that will "match" the *last
instance* of the lookup_value which means it is effectively working from
bottom to top.

--
Biff
Microsoft Excel MVP


"kang" wrote in message
...
the match function gives the index from the top
is it possible to use match from the bottom to the top?
ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"