Hi Stuart.

Here's something else to play with,

Put this in A3 and drag down to A8
=IF(ISNA(MATCH($A$2,B1:AH1,0)),"",MATCH($A$2,B1:AH 1,0))

Then put this in A1
=ADDRESS(MATCH(MAX(A3:A8),A3:A8,0),MAX(A3:A8)+1,4)

It will return the address of the cell where the match with A2 is made,
however,
will fall down if there is more than one match.

If there is going to be more than one match then the same approach
will work but it will need some modifications.

HTH
Martin



"Stuart WJG" wrote in message
...
I need a formula that can look for a date in
a cell that matchs a date in a range and then enter column letter in the
formula cell
Formula in A1
Variable cell (date) A2
Range B1:ah6