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
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