Copy and paste from workbook to another workbook

Debncatz - Feb 24, 2017 at 03:04 PM
Hi, I have a master workbook that has various tables on several worksheets.
The information carries forward to the master page. I copy lines from this workbook, from the master page into another workbook and have not had an issues. Recently, I had to change the pricing from a Vlookup to a Vlookup and Match formula. On the master workbook, it is working properly, but now when I copy and paste to the other workbook, the pricing does not carry forward and gives me a #REF error, guessing because there are multiple formula's. I don't want to copy and paste special before copying to the other workbook, because I need to keep that columns formula intact.
Is there a way to resolve this?

original formula that worked fine copying and pasting
VLOOKUP(H2,'Rate M'!$A$2:$B$83,2,FALSE)

new formula that works that does not copy and paste to the other workbook and gives #REF error
VLOOKUP(H2,'ALL RATE M'!$A:$E,MATCH('Order Status Report'!S2,'ALL RATE M'!$A$1:$E$1,0),FALSE)