"Next" Function

[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

 

[Don Guillett]

look at findnext in vba help index

 

[Alan Beban]

You might want to consider the VLookups function in the freely
downloadable file at http://home.pacbell.net/beban

Alan Beban

 

[Aladin Akyurek]

In order not to repeat a lengthy explanation, here are two links you might
want to look at...

http://makeashorterlink.com/?Z1EA129B5

http://makeashorterlink.com/?Z2FA529B5

 

[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
.