Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: SORTING STOCKS

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    813
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •