Use absolute references..It would be worth to take a look at the below link
http://www.cpearson.com/excel/relative.aspx
--
If this post helps click Yes
---------------
Jacob Skaria
"Dave N" wrote:
I have created a formula that uses a lookup table. I want to copy this
formula and paste it into cells in a column. However, the refence to the
table change as I repeat paste the formula into the subsequent cells. Is
there a way around it?