Index function

S

Shirley

Can you use the match function to return the last match instead of the first?
I know the match type 0 returns the first exact match. I tried using the
match type number that was the same as the quantity of entries to return the
last exact match, but I get an error. Does match type only accept -1, 0, and
1??
 
B

Biff

Hi!

Try this:

.............A............B
1........Tom.........20
2........Joe...........55
3........Sue...........70
4........Tom..........10

C1 = lookup value = Tom

=LOOKUP(2,1/(A1:A4=C1),B1:B4)

Returns 10

Biff
 
Top