Results 1 to 3 of 3

Thread: How to get data without using VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2008
    Posts
    278
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to get data without using VBA

    hi,
    i've data as mentioned below:-

    Input
    Reliance Price DLF Price COAL Price
    15-Del-2013 1000 20-Dec-2013 800 12-Nov-2013 300
    16-Del-2013 2000 22-Nov-2013 850 5-Oct-2013 310
    Output
    15-Del-2013 16-Dec-2013 20-Dec-2013 12-Nov-2013 5-Oct-2013 22-Nov-2013
    Reliance 1000 2000
    DLF 800 850
    COAL 300 310

    In input table i've daywise price of scrips in different columns. In the output table i want to get price as per the respective dates & scrip.

    i was trying to vlookup but got stuck in defining dynamic range.

    Is there a way that i can get this output without using VBA.



    ___________
    Rahul

  2. #2
    Board Regular
    Join Date
    Sep 2008
    Posts
    278
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to get data without using VBA

    got the solution after trying for around 1 hr.

  3. #3
    Board Regular raj2206's Avatar
    Join Date
    Jul 2012
    Location
    Kolkata (India)
    Posts
    210
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to get data without using VBA

    Hi, Could you post the formula.

    Thanks,Raj

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
  •