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 download nd solve itsample.xlsx

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    So you essentially want to filter a list, and copy the filtered result somewhere else? If so, you can use the advanced filter for that.

    If you have excel 2010, here's an example of how to do it:
    1. type the word Symbol in H1
    2. in H2 put the particular text string that you want to filter on. For instance, MBSL.N0000`N
    3. From the Data tab, select Advanced.
    4. Select "Copy to another location"
    5.Input your list range into the 'List range' box i.e. $A$1:$E$2183 in your example file
    6. For the criteria range, select $H$1:$H$2
    7. For the Copy To range, select where you want the files returned to
    8. Push Ok

    A google search will give you more info. Or check out these links:
    http://www.tushar-mehta.com/publish_...lysis/06.shtml
    http://dailydoseofexcel.com/archives...tering-in-vba/ (in case you want to automate this)
    http://www.excelhero.com/blog/2010/0...se-lookup.html has a couple of ways you can do this, with an Advanced Filter (read through the post until you get to the --- UPDATE --- bit that talks about an approach by Sam, and has a link to a workbook here:
    http://www.excelhero.com/blog/workbo...elhero.com.xls

  3. #3
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Hanoof...did this answer your question? It's always nice if you post some feedback when someone has replied to your post.

Posting Permissions

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