VLOOKUP problem

K

Kim

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
 
K

Kim

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
 
B

Bernard Liengme

If I type =TODAY()-1 in A1 and 21/10/2008 in B1 then the formula =A1=B1
returns TRUE
So your method looks OK

If you look in column C of worksheet Data do you see a date fro yesterday?
Suppose it is in C45
On the other sheet try =(TODAY()-1) = Data!C45
Do you get TRUE?

I would be happy to look at the file - use my private email not the
newsgroup
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data automatically from sheet1 to sheet2 0
Consistent Sheet column header rows 2
The custom field could not be saved due to the following reason(s):This formula contains errors. Cor 1
combine three if functions 3
Page numbering with Merged Document and IF statements 1
Goal Seek with variable Set Cell 1
Using VLOOKUP to Sum values from multiple columns 1
vlookup function 2

Top