Maybe, if you give an example, soemone might understand what your problem is?

"talderman" wrote:

The formula that is giving me trouble is VLOOKUP. I need to use absolute
references for the table array so that if the table or the cell that has the
VLOOKUP is moved the cells automatically update. The problem occurs when I
need to copy this information from one tab to another. The table array has
absolute references (for the column and the row) so the cells do not update
or change to some new specified cells on the new tab. I still need the cells
to be absolute references but I would like for them to update to the cell in
the new tab. Can I have my cake and eat it?
--
Tim