Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP problem
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP problem
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP problem
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP problem
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kim" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem w/vlookup | Excel Worksheet Functions | |||
vlookup problem | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLookup problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) |