+ Reply to Thread
Results 1 to 2 of 2

Multiple lookup and multiple results

  1. #1
    Registered User
    Join Date
    07-12-2007
    Posts
    12

    Multiple lookup and multiple results

    I have multiple columns of info. I would like to perform a lookup from 2 columns and return a list of all the matches.



    a................apple................1
    a................peach...............2
    b................apple................3
    c................pear.................1
    a.................apple...............20
    b.................pear................17


    In the above list, I want to return a list for all the a's and apple's which would be:

    1
    20
    If possible I would like to use a formula rather than a code. Any thoughts?

    Thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Use autofilters or advanced filter?
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1