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