Select the cell with the formula you want to copy
Highlight the formula in *the formula bar*
Copy the formula then hit Escape
Navigate to the other file and paste the formula where you want it

--
Biff
Microsoft Excel MVP


"Elton Law" wrote in message
...
Dear Expert,

Want to copy a function from one spreadsheet to another spreadsheet
(different file name).
I just want to copy a function (as follows) from Tolerence Checker.xls to
Tolerance Checker.xls (Different file name ... one is Tolerence and
another
os Tolerance ....

From file Tolerence Checker.xls,
=IF(VLOOKUP(A2,'Ignore List'!A:B,1,FALSE)=A2, "YES", "NO")

After copying .... in Tolerance Checker.xls,
=IF(VLOOKUP(A2,'[Tolerence Checker.xls]Ignore List'!A:B,1,FALSE)=A2,
"YES",
"NO")

The forumla becomes cross-link from Tolerence Checker which is unnecessary
...

How to copy so that this can be avoided please ?
Thanks