Formulas in Sheet1 (referring to dates in column Q):
=VLOOKUP(Q16,data!$C:$BM,9,FALSE)
=VLOOKUP(Q17,data!$C:$BM,9,FALSE)
Formulas in Sheet2 (calculating % variance between H and F):
=H315/F315-1
=H316/F316-1
--
-Kim
"Bernard Liengme" wrote:
Show us the formula you are using, please
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Kim" wrote in message
...
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