Help Please

[Gusher]

Hi Everybody,

In row 1 I have dates
In row 2 I have names

In cell c5 I have a name that appears in row 2
In cell c6 I need a function that will return the date for that name in cell C5. So for example if cell cell bb2 = Red and cell bb1 = 23/1/2010 then when Red is entered into cell c5 then cell c6 returns 23/1/2010. I should add that the names in row 2 are all unique but the dates in row 1 are not.

Many thanks for any help, Mark

 

[FormR]

Hi, sounds like a simple INDEX(MATCH()) for example:

=INDEX(1:1,MATCH(C5,2:2,0))

 

[peterhinton]

=index(1:1,1,match(c5,2:2,0))

 

[Gusher]

Hi, sounds like a simple INDEX(MATCH()) for example:

=INDEX(1:1,MATCH(C5,2:2,0))

many thanks, that worked, Mark