Trying to match two colums if critera is meet, but leave formula out if not.

Look at the attached workbook:

I took your original file and added an autoexecute macro that restores the formula that may previously overwritten by the user

Notes:

- This uses an autoexecute macro

- To work, the user must allow macros. If they say no to macros, this won't work

- The file uses an area to the right of the print area to "store" the formulas.
The area is formated in white font so it will not be seen

- When the file is opened, the "Ship To" area is reset so what the user entered before is erased.
However, if the file is opened without macros enabled, the user data is not overwritten

- You need to reset your password protection as this file is not password protected