Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kim Kim is offline
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Kim Kim is offline
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem w/vlookup Sandy Excel Worksheet Functions 5 October 13th 08 02:05 PM
vlookup problem Robbyn Excel Worksheet Functions 10 August 6th 07 02:49 AM
VLOOKUP Problem Tosca Excel Worksheet Functions 7 July 23rd 05 10:43 PM
VLookup problem K Excel Worksheet Functions 6 June 8th 05 10:35 PM
VLOOKUP problem Jaladino Excel Discussion (Misc queries) 1 March 2nd 05 05:02 AM


All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"