Looking for LOOKUP function that return the last matching value

[didierk]

Hello,

Is there any function such as Vlookup that return the last matching value?

There is nothing that I find that can easily do that..

Thank you.

[windknife]

Try this in C2 and copied down.
=LOOKUP(2,1/($H$2:$H$1000=A2),$M$2:$M$1000)

[didierk]

Thank you.
It works well, now I have to try to understand the formula LOOKUP better as I did look at using it previously.

[AliGW]

Are you still using Excel 2007?

[windknife]

You are welcome.