|
Answer» 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
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]...Remember the formula in the above is an array formula.
|
