Require a formula to find the occupied cell in a list and return a value.

Hi

I have a list of information -

Date Name
01/07/2014
02/07/2014
03/07/2014
04/07/2014
05/07/2014
06/07/2014
07/07/2014
08/07/2014
09/07/2014
10/07/2014
11/07/2014
12/07/2014
13/07/2014
14/07/2014 John Dalton
15/07/2014 John Dalton
16/07/2014 John Dalton
17/07/2014 John Dalton
18/07/2014 John Dalton
19/07/2014
20/07/2014
21/07/2014
22/07/2014
23/07/2014
24/07/2014
25/07/2014
26/07/2014
27/07/2014
28/07/2014
29/07/2014
30/07/2014
31/07/2014


I need to return the date of the frist instance my name appears which would be 14/07/14

Cheers

JD

Try

=INDEX(A:A,MATCH("John Dalton",B:B,0))

Cheers guys great result.

JD

You're welcome.