Again trying to explain my issue fails me.
I am using VLookup formulas on a worksheet named 'RunRate_w2021'. The formula is
=IFERROR(VLOOKUP($C3,Skus!$A:$CZ,7,FALSE),"")
The Lookup Value for the formula is on another worksheet ('Skus) of the workbook. Every Monday I copy and paste values of an updated list into the 'Skus' worksheet.
The result and issue is that only some of the rows of 'RunRate_w2021' worksheet return a value even if the Lookup Value is on the Skus worksheet.
I can resolve it if I manually retype the Lookup Value into the reference cell on the 'Skus' worksheet as the formula works correctly and populates the results on the 'RunRate_w2021' worksheet. This Lookup Value cell is marked as Text in both worksheets as it is an 8-digit number and some can begin with a zero.
To try to make it simple, something breaks when I update the 'Skus' worksheet, resulting in formulas not providing results in the 'RunRate_w2021' worksheet.
Remember my update of the Skus worksheet is a copy and paste values. Is there a different way I need to paste these so this formula doesn't break?
Bookmarks