how do I paste copied formulae without losing refences to tables?

[Dave N]

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?

 

[Dave Peterson]

You could name the table
select the table
Insert|Name|Define (in xl2003 menus)

Or you could make sure that the address is written with absolute references.
=vlookup(a1,sheet2!$a$1:$b$33,2,false)

Or if the table is on a dedicated sheet, just use the entire column:
=vlookup(a1,sheet2!a:b,2,false)

 

[Dave Peterson]

You could name the table
select the table
Insert|Name|Define (in xl2003 menus)

Or you could make sure that the address is written with absolute references.
=vlookup(a1,sheet2!$a$1:$b$33,2,false)

Or if the table is on a dedicated sheet, just use the entire column:
=vlookup(a1,sheet2!a:b,2,false)

 

[Jacob Skaria]

Use absolute references..It would be worth to take a look at the below link

http://www.cpearson.com/excel/relative.aspx

 

[Jacob Skaria]

Use absolute references..It would be worth to take a look at the below link

http://www.cpearson.com/excel/relative.aspx