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