See his reply to my question - looks like you gave him good solution anyhow.

"Pete_UK" wrote:

Sorry, I thought your range was B1:AH1 - ignore my post.

Pete

On Aug 29, 2:29 pm, Pete_UK wrote:
Put this in A1:

=IF(ISNA(MATCH(A2,$B$1:$AH$1,0)),"",IF(MATCH(A2,$B $1:$AH
$1,0)25,"A"&CHAR(MATCH(A2,$B$1:$AH$1,0)+39),CHAR( MATCH(A2,$B$1:$AH
$1,0)+65)))

Hope this helps.

Pete

On Aug 29, 1:38 pm, Stuart WJG
wrote:



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- Hide quoted text -

- Show quoted text -