find column letter
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 -
|