Weeks and days sorting out
=VLOOKUP(Sheet2!A1,Sheet3!$A$2:$C$30,3,TRUE)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"vivi" wrote in message
...
Hi
thanks for your post and your suggestions but unfortunately I've tried it
but it doesn't work for me, maybe I've haven't explained myself correctly
The first sheet contained a daily sales figure from 01/01/06 to 30/09/06
E.G.
01/01/06 £500
02/01/06 £600
03/01/06 £400
04/01/06 £600
05/01/06 £700
06/01/06 £500
07/01/06 £400
What I want to do is that from my lookup table in the 2nd Sheet, I have
this
figures:
To From Week No.
31/12/2005 06/01/2006 1
07/01/2006 13/01/2006 2
14/01/2006 20/01/2006 3
21/01/2006 27/01/2006 4
28/01/2006 03/02/2006 5
So on my first sheet I would like to have a column to show me which
number
of week does a day falls into e.g.
Date: £: Week no.
01/01/06 £500 1
02/01/06 £600 1
03/01/06 £400 1
04/01/06 £600 1
05/01/06 £700 1
06/01/06 £500 1
07/01/06 £400 1
08/01/06 £500 2
I've used your formula but I could onlu get an answer to the first cell
but
then all the others are incorrectly showing zeros, is there other formulas
that I can use?
Thanks a lot
Vivi
"Bob Phillips" wrote:
=SUMPRODUCT(--(Sales!A1:A1000=A2),--(Sales!A1:A1000<=B2),Sales!B1:B1000)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"vivi" wrote in message
...
Hi there I hope someone could help me
I've got a column of dates in column A and the sales for each date in
column B
What I need to do is that I have to classify these daily sales figures
into
weekly sales figures downloaded onto my "Sales!" sheet
Then I've created a new sheet "Sheet1!"and put the to and from date in
column A and B and the week number in column C
For example
Date From Date To: Week Number:
01/01/2006 07/01/2006 1
08/01/2006 15/01/2006 2
I would like to do a lookup in my downloaded daily sales figures and
I've
put a formula:
If(Sales!A1<Sheet1!B2,if(Sales!A1Sheet!A1,vlookup (Sales
A1,Sheet!A:C,3,0),"Checking")
However it doesnt work, can somebody please help me and tell me what
have
I
done wrong and how should I put it right please?
Thanks a lot
Vivi
|