INDENTIFY COLUMN

[Stuart WJG]

i WOULD LIKE TO ABLE TO INDENTIFY COLUMN THAT A DATE IS IN

I.E IF DATE IS IN EG B17 THEN I NEED A FORMUAL SAY IN A1 THAT WILL IDENTIFY
AND ENTER B IN THE COLUMN.

THANKS
sTUART

 

[Gaurav]

hAVE YOU LOST YOUR caps LOCK KEY?

 

[Stuart WJG]

Hi
perhaps not made myself clear. 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
Hope this clarifys
Stuart