Vlookup with 2 ranges in one worksheet

[Eelco Wiertsema]

Ok what I need to do is to get the number from a certain cell with all kinds
of data (Stocks) into a worksheet in wich I can modify my investments.
Now the problem is that I get the data in the following order:

DATE COMPANY HIGH LOW VOLUME
x x x x x

What I would like now is that as I will have to add more data that the
'HIGH' and 'LOW' will be copied within a formula to another worksheet in
which the Date can be found on the different rows and all the companies are
filled in the columns now there are 24 different companies I have to aquire
the stockindexes from.

Will this be possible? What I can do is to get all the first stock indexes
correctly but as I try to autofill all the dates it doesn't seem to work with
only just the VLOOKUP formula!

Any help will be greatly appreciated.

 

[Biff]

Hi!

Can't really tell what it is you want.

Can you provide more detailed info? Be very specific.

Biff

 

[Eelco Wiertsema]

Date Company Name Mnemonic opening
3-1-2005 ABN AMRO HOLDINGAABA 19,53
3-1-2005 AEGON AGN 10,09
3-1-2005 AHOLD KON AH 5,67
3-1-2005 AKZO NOBEL AKZA 31,25
3-1-2005 ASML HOLDING ASML 11,76
3-1-2005 BUHRMANN BUHR 7,2
3-1-2005 DSM DSM 47,51
3-1-2005 ELSEVIER REN 10,04
3-1-2005 FORTIS FORA 20,44
3-1-2005 GETRONICS GTN 1,68
3-1-2005 HAGEMEYER HGM 1,72
3-1-2005 HEINEKEN HEIA 24,55
3-1-2005 IHC CALAND IHC 46,65

So this is my Data input as I can download it from the server what I would
like now is that this number you can see under opening is being looked up in
another worksheet.
But now the A column states all the different dates and the first row states
the different companies so that i don't have to copy everything by hand.
As you can see the date here is only the 3rd of january but in the complete
worksheet this must accumulate to a whole year as time goes by and I can
download the data weekly.

Like this:

AABA

Date Open End
3-01-05 € 19,53 € 19,70
4-01-05 € 19,65 € 19,82
5-01-05 € 19,66 € 19,76
6-01-05 € 19,80 € 20,48
7-01-05 € 20,46 € 20,65
10-01-05 € 20,56 € 20,58
11-01-05 € 20,52 € 20,28
12-01-05 € 20,24 € 20,06
13-01-05 € 20,14 € 20,09
14-01-05 € 19,98 € 20,11
17-01-05 € 20,17 € 20,27
18-01-05 € 20,51 € 20,56
19-01-05 € 20,64 € 20,69
20-01-05 € 20,62 € 20,61
21-01-05 € 20,53 € 20,73
24-01-05 € 20,66 € 20,64
25-01-05 € 20,72 € 20,84

And then if this would be columns A through C but in the complete worksheet
it goes through to AQ

Again is this possible?

 

[Biff]

Hi!

This should be pretty easy but there are a couple of
things that I don't quite understand.

Do you download the raw data daily? And if so, after you
have that data sorted out to the other sheet do you delete
the raw data?

Where do you get the closing values?

I can think of a few different ways to do this but at the
same time it sounds like this file is very big and would
require a lot of formulas.

Have you considered using a pivot table or even a database
program?

To come up with a specific solution I would need to see
the file.

Biff

 

[Eelco Wiertsema]

To your first question yes but sometimes I've been away for a while and then
I download a lot of info at the same time.
then no I do not delete the raw data but it's being copied into the sheet
aswell.
The closing values I would like to treat the same.

All of this is for my own convenience so that the worksheet will do all the
work it self and I don't have to copy and paste every day.

I would like to send you the file but I don't know how to do it here! Any
suggestions?

 

[Biff]

Hi!

If the file is under 1 mb in size send it to:

Biff, is valko01 at comcast dot net.

If it's over 1 mb:

Goto this site and upload the file:

http://s30.yousendit.com/

Just follow the directions. It's very easy.

Biff