need to retrieve dates from lookup

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

Try this:

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

Format the cell as DATE.

Biff

"MRT" <MRT@discussions.microsoft.com> wrote in message
news:EDAFA136-EB83-4ACE-8C2D-C31DE8109FB3@microsoft.com...
> 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
>
>
>