I have two work sheets. The first contains the static client data while the
second records individual contacts with each client.

Looks like this;

Sheet 1
A B C D
# Ref# First Name
1 654 Sam Fisher
2 123 Sam Jones
3 688 Harry Smith
4 478 John Johanson

Sheet 2
A B C D E
Date # Ref# First Last
05/05/08 1 654 Sam Fisher
15/08/09 1 654 Sam Fisher
15/08/09 3 688 Harry Smith
15/08/09 4 478 John Johanson
15/08/09 5 987 Laurey Dessmond

I need a formula that can extract the most recent date we had contact with a
client based on the client #. In the case of Sam Fisher that would be the
number 1.

The formula would sit in column e on sheet 1

Is this possible? Please help

Thanks