As the file is only 520kb, I'd rather see the full file with sensitive information removed BUT displays the problem, rather than a cut down version that doesn't.
That said ...
On Sheet Item#s, this could be just this
On this sample, the Conditional Formatting is split. So, if that is the case in the real file, you could have a lot more CF than you need. I'd be inclined to remove all the CF and re-apply it.
On the Stampin' Rewards sheet, you might be better off using INDEX/MATCH rather than VLOOKUP. There is an argument that VLOOKUP will require you to read the whole search range into store even though you only search the first column and return data from one other, whereas, INDEX/MATCH only refers to two columns.
So this: could be this:
Could be other things but obviously I'm not going to be able to test the benefits of these suggestions.
If there are other sheets, there may be other issues that I cannot comment upon.
Bookmarks