You said the CF formula works when there is a $ in it.
The dollar sign means to always use that column (or row) for the comparison. It sounds like you want to use a different CF formula in other columns?
I'm not sure where you are with your question now.
I hope you understand the $ in the formula. If not a very simple explaination can be found at
http://www.homeandlearn.co.uk/excel2...l2007s7p5.html