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.