I have a large spreadsheet with multiple sheets. On Sheet 3 I have a list of 3 types of values in column A, B and C. On sheet 1, when a number from column A on Sheet 3 is entered it will pull the information from Columns B and C on sheet 3 and insert it into the appropriate cells. For some reason, today the VLOOKUP is trying to pull from Sheet 2 C284 (which it has never been set to do and there is nothing even there).
Sheet 1 = "Open Orders" (this is a table)
Sheet 2 = "Closed Orders"
Sheet 3 = Materials (contains GCASLookups)
Original that works:
=VLOOKUP(C195,GCASlookups,2,FALSE)
Random one that showed up today:
=VLOOKUP('Closed Orders'!C284,GCASlookups,2,FALSE)
I have gone through the whole thing and this new formula only shows up in when I insert a row (how we add a new entry). It was working fine before now and I'm not sure what changed.
I can get it to revert back just by dragging down the value from above with the correct formula, but every time I use my macro that adds a new line, it brings up the wrong formula. I have been through my macro and it shouldn't affect formatting in any way. And everything on this sheet has worked perfectly till now.
How do I get this to change back and to stay the original way when we insert a new row into the table on Sheet 1?
Thanks for any help in advance!
Bookmarks