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