I have a list of data in which A:A lists names B:B lists date of status
change and C:C lists the person's status as of the date in B. I need to find
the status for each person listed in column A as of 09/30/07, as of 09/30/08,
and as of 09/30/09). Any suggestions?

A B C
John Smith 04/01/88 Available
John Smith 04/30/97 Active
Jane Doe 09/28/07 On Leave
Jane Doe 10/02/07 Active
Jane Doe 11/07/07 Available
Jane Doe 01/08/08 Active
Polythene Pam 07/27/05 Available
Polythene Pam 08/23/05 Active
Polythene Pam 03/30/06 Resigned

Many thanks!

Gina