Assuming that A2:C7 contains the data, try...

=LOOKUP(2,1/(A2:A7="Fred"),C2:C7)

Hope this helps!

In article ,
Smugga wrote:

I am trying to lookup the last entry of a name in an array. For example:

A B C
1 Fred 5 1/5/05
2 Barbey 4 1/6/06
3 Betty 10 2/12/06
4 Fred 7 5/15/06
5 Wilma 7 6/1/06
6 Dino 2 6/12/06

=vlookup("Fred",a1:c4,3,1) will only give me the first "Fred" date (1/5/05)
in column C. I am looking for a way to return the last entered "Fred".