I am working on creating a purchase order template, and I am using Vlookup to gather part descriptions from a part number.
The lookup I am using is this:
=IF(F25=0,"",VLOOKUP(F25,'f:\dir\dir\filename.xlsm'!parts,2,FALSE))
The file is on a networked drive. I intend for more than one location to be able to use the template, so they all need to have access to the parts table. The lookup works as written.
The problem I have is that excel is changing the formula to the following for some reason:
=IF(F25=0,"",VLOOKUP(F25,'filename.xlsm'!parts,2,FALSE))
This causes the formula to fail and fires an "undefined or non-rectangular error" when the template loads. If I then open the parts file on my desktop, the lookup works and I get my descriptions.
I have no idea what is causing the formula to change, and numerous attempts to change the cells back to the original formula are not working. There are other lookups doing similar things for vendor information that do not cause this issue. It only occurs with the parts lookup.
What is causing the formula to change?
The lookup I am using is this:
=IF(F25=0,"",VLOOKUP(F25,'f:\dir\dir\filename.xlsm'!parts,2,FALSE))
The file is on a networked drive. I intend for more than one location to be able to use the template, so they all need to have access to the parts table. The lookup works as written.
The problem I have is that excel is changing the formula to the following for some reason:
=IF(F25=0,"",VLOOKUP(F25,'filename.xlsm'!parts,2,FALSE))
This causes the formula to fail and fires an "undefined or non-rectangular error" when the template loads. If I then open the parts file on my desktop, the lookup works and I get my descriptions.
I have no idea what is causing the formula to change, and numerous attempts to change the cells back to the original formula are not working. There are other lookups doing similar things for vendor information that do not cause this issue. It only occurs with the parts lookup.
What is causing the formula to change?