Blank cells returned from formula corrected by manually typing lookup value

[msdclark]

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?

[JohnTopley]

This a data not formula problem: if C3 exists in the SKU VLOOKUP will return the value: errors occur if there is a data mismatch.

To help, a sample workbook is needed: see yellow banner at top of page on how to post a workbook. If possible include the Copy/Paste worksheet.