Return last value of a searchvalue in a table

[VeKa27]

Hi,

I have a table with more then one time the same name in clolumn A.
If i use INDEX and MATCH formula for that name to return the value of column B, it gives always the first found value. But now i want the last found value? How can i fix this?
I don't want to use the filter.

=INDEX(B5:B500,MATCH(C1,A5:A500,0))

Thanks

[MarvinP]

Hi VeKa,

You use the Lookup() function that never gets to the end like:
https://www.exceltip.com/excel-formu...ing-value.html

See the formula in my attached below:
Lookup Last Match.xlsx

[Fluff13]

How about
=LOOKUP(2,1/(A5:A500=C1),B5:B500)

[VeKa27]

Ok, both solutions worked for me.
I used the Fluff13-way.. :-)

Thanks a lot for both inputs

[Fluff13]

You're welcome & thanks for the feedback.