Try this:

=INDEX(B1:H1,MATCH("1C",B2:H2,0))

Format the cell as DATE.

Biff

"MRT" wrote in message
...
I'm sorry...

Yes, I have dates 3/1/06 - 3/7/06 in one row B1:H1. And in B2:H2 has
"1C",
"2C", "3C" and blank cells. In cell D6, I want to create a formula that
will
give me the date that corresponds with "1C". For example if "1C" is in
C2, I
want to get the date that is above C2. The cell above C2 is C1 with the
date
3/2/06. So now I want the date 3/2/06 to appear in the designated cell
(D6).

3/1/2006 3/2/2006 3/3/2006 3/4/2006 3/5/2006 3/6/2006 3/7/2006 1C 2C 3C