Thread: Transferring equations

I am trying to move one eqaution to another page but everytime I copy and paste the equation it changes. Is there anything I can do to make the equation go from one spreadsheet to another? The equation is going from one file to another not between two sheets on the same file.

Example.

=IF(ISNA(VLOOKUP(B2,data,2,FALSE)),"NO MATCH",(VLOOKUP(B2,data,2,FALSE)))

This is the equation that I would copy from the first spreadsheet. And when it transfers to the other page the equation changes to this:

=IF(ISNA(VLOOKUP(AD2,data,2,FALSE)),"NO MATCH",(VLOOKUP(AD2,data,2,FALSE)))

Hi,

If you're copying from one cell reference and pasting to a different cell reference whether in a new workbook or new sheet, then the formula will be different unless you make the cell reference an absolute reference by prefixing the column and row ref with a $. i.e. use $B$2 not B2.

HTH

Thanks!!!!