Index function

[Guest]

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??

 

[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

 

[Guest]

Thank You, I will try that this morning instead of Index.

 

[Biff]

You're welcome!

Biff

Thank You, I will try that this morning instead of Index.