S
Sbee
Hi all, new to forum and found it by being totally stuck 
Basically, I've got some information for example:
(A) (B) (C)
Date Total
10/10/03 10
11/10/03 30
13/10/03 199
13/10/03 100
Now I want two different worksheets, One for a Main Part, one for
cumulative Data, I'll name them Main & Data
Now what I want is on the main page, a search-type function, which will
check the data page, for dates, it will then fill in the info on the
main page.
Using a normal vlookup this is easy enough, something like:
=vlookup(date from the main sheet which is entered, range on the second
worksheet, 2)
That'll display the 'total' in the row I want, now this works fine for
them 1by1, now the problem is when I've got two dates, it will check
the first date, and then add it, but the second date is the problem
I've got.
-------------------
Prolly gonna sound either weird or confusing....
My idea.. well theory which works on paper... well in my head would be
to add a 3rd column for example:
(A) (B) (C)
Date Total
10/10/03 10 A3
11/10/03 30 A4
13/10/03 199 A5
13/10/03 100 A6
The 3rd column, would be the location of the dates, so in a way, i'd
make it do a vlookup, when it finds a date, it then re-selects the area
below, so the formula would be like:
=vlookup(DATE, AREA, ARRAY)
Lets just say the date cell is D1, and I've got a vlookup on the second
sheet (At F1), so that I know were the previous vlookup got its value
from;
so.. =vlookup (D1, F1:C7, 2)
The problem I've got is, that when I link F1, it uses F1 cell location,
not the contents of the cell, just wondering, is there anyway at all of
making the link use the cell contents rather than the location, or any
other ways of.. completing what I want, I know it would be alot easier
to use a database, unfortunately it isn't a option, Anyhelp greatly
appreciated, thanks!.
Basically, I've got some information for example:
(A) (B) (C)
Date Total
10/10/03 10
11/10/03 30
13/10/03 199
13/10/03 100
Now I want two different worksheets, One for a Main Part, one for
cumulative Data, I'll name them Main & Data
Now what I want is on the main page, a search-type function, which will
check the data page, for dates, it will then fill in the info on the
main page.
Using a normal vlookup this is easy enough, something like:
=vlookup(date from the main sheet which is entered, range on the second
worksheet, 2)
That'll display the 'total' in the row I want, now this works fine for
them 1by1, now the problem is when I've got two dates, it will check
the first date, and then add it, but the second date is the problem
I've got.
-------------------
Prolly gonna sound either weird or confusing....
My idea.. well theory which works on paper... well in my head would be
to add a 3rd column for example:
(A) (B) (C)
Date Total
10/10/03 10 A3
11/10/03 30 A4
13/10/03 199 A5
13/10/03 100 A6
The 3rd column, would be the location of the dates, so in a way, i'd
make it do a vlookup, when it finds a date, it then re-selects the area
below, so the formula would be like:
=vlookup(DATE, AREA, ARRAY)
Lets just say the date cell is D1, and I've got a vlookup on the second
sheet (At F1), so that I know were the previous vlookup got its value
from;
so.. =vlookup (D1, F1:C7, 2)
The problem I've got is, that when I link F1, it uses F1 cell location,
not the contents of the cell, just wondering, is there anyway at all of
making the link use the cell contents rather than the location, or any
other ways of.. completing what I want, I know it would be alot easier
to use a database, unfortunately it isn't a option, Anyhelp greatly
appreciated, thanks!.