HI Ben;
Can you refrase the question a little. I don't think your question is clear.
What do you mean by rotatiting? You mean that you want the formula always
pointing to Col "A"?

Argy

"Ben" wrote:

I have a list of Numbers in Col A from a6:a39
Have formula in Col L =if(A6=1590,4502,"") thru to =if(A39=1590,4502,"")
in Col L.Some specific numbers need to stay in specific cells in Col L.
When I put 1590 in any cell from A6 to A39,in Col L the result is 4502 in
the corresponding cell. The trouble is when I rotate Col A my formula in Col
L advances by one eg A6 becomes A7 and so on. I do not want to rotate Col L.
as some cells with specific numbers need to stay in those cells. How do I
stop the formula in Col L from changing. Using absolutes does not fix.
--
Reynella