+ Reply to Thread
Results 1 to 4 of 4

Lookup on 1 criteria but returning multiple results

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    england
    MS-Off Ver
    excel 2010
    Posts
    2

    Lookup on 1 criteria but returning multiple results

    Hi,
    Advance apologies if this has been solved elsewhere as I may not have searched for the correct wording.

    I am looking for a way to do a look up on 1 column that may have duplicate entries and return all results for a match (not just the first one).


    I.e. based on below example, I need to find a way to lookup on column A (the fruit) and return all of the matches for this look up from column B (the colours):

    Banana Blue
    Apple Blue
    Banana Red
    Pear Yellow
    Banana Yellow

    So I am looking to return in 3 separate fields:
    Banana Blue Red Yellow

    Hope this is clear.

    Many thanks in advance!

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Lookup on 1 criteria but returning multiple results

    Look at this link from last week

    http://www.excelforum.com/excel-new-...first-one.html
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Lookup on 1 criteria but returning multiple results

    Hi swingding

    See the attached file, using the INDEX function. Is this the result that you are after!
    Last edited by Kevin UK; 02-07-2013 at 06:19 AM.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    england
    MS-Off Ver
    excel 2010
    Posts
    2

    Re: Lookup on 1 criteria but returning multiple results

    Thank you so much both of you for taking the time to reply! Works a treat - many thanks :o)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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