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


"Gaurav" wrote:

hAVE YOU LOST YOUR caps LOCK KEY?


"Stuart WJG" wrote in message
...
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