SORTING STOCKS

[verluc]

I have in a workbook 2 sheets: sheet A and sheet B.
In sheet A I have in the column A1:A250
a number of 250 symbols from stocks of the NASDAQ.
In sheet B I have download the hole NASDAQ stock exhange of about +/- 7000 stocks;
Now what I want to do is every day in column B of sheet A set the stock PRICES with the same symbol as of sheet B
Is this possible?
Many thanks

 

[smozgur]

A_col | B_col

1 | =VLOOKUP(A1,SheetB!A1:A7000,1,FALSE)
2 | =VLOOKUP(A2,SheetB!A1:A7000,1,FALSE)
3 | =VLOOKUP(A3,SheetB!A1:A7000,1,FALSE)
..
..
..

SheetB should be sorted in ASC by A column.

_________________
Oz ~ TheWordExpert
This message was edited by smozgur on 2002-03-19 08:54
This message was edited by smozgur on 2002-03-19 08:55