Hi

Is it possible to drop a numeric value from one cell into another and have the new cell recognise the value. What I get at the momment is a #REF in the cell that responds to the value being dropped in.

i.e. 1. Cell A1 has a 2 in it.
2. Drag that to cell B1
3. C3 has an if statement that resonds to the value in B1 "if B1 = 2 then.." and so on

Doesn't work, what I get is 'B1' replaced by #REF

Anyone help?

Thanks