Hi guys,

Lets take this scenario:

Brian 20
Michael 30
Ivan 40
Brian 30
Ivan 60
Michael 70

I want to apply a vlookup on this list but return the last
value i.e. Brian 30, Ivan 60 & Micahel 70

I tried the -1 instead of the 0 in the last field of the
formula but this still did not work correctly.

Any suggestions ..???

Thanks,
Brian