Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: How to use Excel Worksheet Functions to find multiple association  (Read 3487 times)

0 Members and 1 Guest are viewing this topic.

lwkt

    Topic Starter


    Rookie

    I'm using a Excel formula to pull data from a raw excel file onto a summary
    sheet. The issue is that the VLOOKUP/INDEX/MATCH will pull the first--and
    only the first--match (relative or exact-MATCH) it finds.

     If I am looking for a single formula code that has multiple associations, what function would I use to return those multiple values?

     For example, if I am using a VLOOKUP/INDEX/MATCH formula to find a
     name(Tommy) and return the country in which he lives, and
     there are five Tommy who live in England, Germany, Italy,
     US, and Australia, what kind of formula would I use that would return ALL the values (countries)in subsequent rows instead of the first one found (such as England)?

    Thanks,
    lwkt

    Salmon Trout

    • Guest
    Re: How to use Excel Worksheet Functions to find multiple association
    « Reply #1 on: April 17, 2017, 06:14:45 AM »
    You mean like this? Click image to enlarge)


    See here

    http://eimagine.com/how-to-return-multiple-match-values-in-excel-using-index-match-or-vlookup/


    [attachment deleted by admin to conserve space]
    « Last Edit: April 17, 2017, 06:29:23 AM by Salmon Trout »

    Salmon Trout

    • Guest
    Re: How to use Excel Worksheet Functions to find multiple association
    « Reply #2 on: April 17, 2017, 06:21:44 AM »
    ...

    Salmon Trout

    • Guest
    Re: How to use Excel Worksheet Functions to find multiple association
    « Reply #3 on: April 17, 2017, 01:39:54 PM »
    Remember the formula in the above is an array formula.