I'm using VLOOKUP in Sheet1 to pull in column C from Sheet2 containing
percentage variances from columns A and B.

The problem is that for yesterday's date, which is =TODAY()-1, it's not
pulling the correct percentage. Very weird. It's pulling in 0% variance,
which is not what I see on Sheet2, Column C.

The odd thing is that the variances for all other days before yesterday are
being pulled in correctly.

Any suggestions?


-- Thanks,
-Kim