Results 1 to 2 of 2

Thread: How do I get Vlookup to return multiple matches?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    How do I get Vlookup to return multiple matches?

    How do I get Vlookup to return multiple matches?
    i hv sample.xlsx

    Symbol Time Price Quantity
    GREG.W0006`N 14:59:59 2.1 1,000
    CLPL.W0014`N 14:59:59 3.1 902
    CLPL.W0014`N 14:59:59 3.1 1,000
    YORK.N0000`N 14:59:56 17.6 1,900
    DIAL.N0000`N 14:59:56 9.3 1,000
    BIL.N0000`N 14:59:56 3.3 3,000
    MBSL.N0000`N 14:59:55 19.3 500
    MBSL.N0000`N 14:59:55 19.3 200
    MBSL.N0000`N 14:59:55 19.3 100
    MBSL.N0000`N 14:59:55 19.3 1,000



    I Want lyk this

    time price volume
    MBSL.N0000`N 14:59:55 19.3 500
    14:59:55 19.3 200
    14:59:55 19.3 100
    14:59:55 19.3 1,000
    14:59:55 19.3 10,000
    14:59:55 19.4 500
    14:59:55 19.4 2,000
    14:59:55 19.4 100
    14:59:55 19.4 1,500
    14:59:55 19.4 2,000
    pls download nd solve thise sample.xlsx
    Last edited by HANOOF; 06-04-2013 at 06:00 PM.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    See possible answers at the bottom of this page.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Vlookup to Return Multiple Values
    By Admin in forum Download Center
    Replies: 9
    Last Post: 02-17-2017, 07:03 PM
  2. Replies: 4
    Last Post: 04-24-2013, 10:04 AM
  3. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 PM
  4. Vlookup with multiple criteria
    By patsir in forum Excel Help
    Replies: 7
    Last Post: 08-27-2012, 11:15 AM
  5. VLOOKUP with Multiple Results
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-26-2011, 10:29 PM

Posting Permissions

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