"Next" Function

  • Thread starter Thread starter EU
  • Start date Start date
E

EU

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

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

For example, if I am using a VLOOKUP formula to find a
name (Mike)and return the country in which he lives, and
there are five Mikes 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 (in this case England)?

Thanks

EU
 
-----Original Message-----
I'm using a VLOOKUP formula to pull data onto a summary
sheet. The issue is that VLOOKUP will pull the first--and
only the first--match (relative or exact-MATCH) it finds.

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

For example, if I am using a VLOOKUP formula to find a
name (Mike)and return the country in which he lives, and
there are five Mikes 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 (in this case England)?

Thanks

EU
.
Click to expand...
 
Back
Top