Computer Hope

Software => Computer software => Topic started by: lwkt on April 16, 2017, 08:44:25 PM

Title: How to use Excel Worksheet Functions to find multiple association
Post by: lwkt on April 16, 2017, 08:44:25 PM

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

Title: Re: How to use Excel Worksheet Functions to find multiple association
Post by: Salmon Trout on April 17, 2017, 06:14:45 AM

You mean like this? Click image to enlarge)
(https://i.imgbox.com/cX76BbVX.jpg)

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]

Title: Re: How to use Excel Worksheet Functions to find multiple association
Post by: Salmon Trout on April 17, 2017, 06:21:44 AM

...

Title: Re: How to use Excel Worksheet Functions to find multiple association
Post by: Salmon Trout on April 17, 2017, 01:39:54 PM

Remember the formula in the above is an array formula.