Results 1 to 3 of 3

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

  1. #1

    How do I get Vlookup to return multiple matches?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 PM 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 solve this wrk sheet sample.xlsx

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Duplicate post...I've posted a solution at the other identical thread at http://www.excelguru.ca/forums/showt...ltiple-matches

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    The usual solution is to use a concatenation formula. Don't, excel runs out of memory. Go to your data sheet and add a new column. Set this to join your fields, e.g. =A1 & B1. Then in you lookup do =vlookup(date & time, datarange,column,false)

Posting Permissions

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