I want to use a "IF" formula on one worksheet to look in column A1 and put
the result of column B1 as a result, if A1 = 1, then be able to copy this
formula across so it still looks to column A1 and puts in C1 if A1=1. I can
do this by making A1 an abosolute reference but then this formula wont copy
down so that the next row looks at A2 is there a way of doing this with a
"IF" formula or should I be using something else?

Regards Davidm