I have a table with names in A, dates in B and text in C.
I'm looking for a formula (prefer not a UDF()) that will pull column C for the latest date for a name.

Example (this is on sheet 2)
Name    Date    Action
Bill    1/1/10  Opened
Dave    1/1/10  Closed
Bill    3/1/10  Tallied
I want to find what did Bill do last? Answer he Tallied. put onto sheet1 next to Bill's name
I also need to know the same thing for Dave, and everyone else in the list.

I can find the latest day for everyone by using the array formula ={LARGE(IF(sheet2!A$1:A$518=sheet1!$A1,sheet2!$B$1:$B$518),1)} or something similar, but I can't figure out how to then get the action from column C.