Using VLOOKUP,what if I have more than one occurence of my Lookup.
 

I am trying to create a function that will look up each occurence of the
Lookup value and return the corresponding name. Is this possible and if so,
how do I do it?

I would personally use the autofilter for this and copy and paste filtered
list, there are some workarounds using index and small which can be seen here

http://tinyurl.com/56nv4


Regards,

Peo Sjoblom

"Mondie" wrote:

I am trying to create a function that will look up each occurence of the
Lookup value and return the corresponding name. Is this possible and if so,
how do I do it?

I have several lists to create. I tried looking at the reference you
supplied, but it returns an error message.

Here is the part of the table I am working with:
Class Name
1 02 John
2 03 Sally
3 05 Jim
4 02 Tom
5 03 Joe

What I need to do is put all of the "02's" on one sheet, the "03's" on
another sheet, and so on. I only need the names to post to the other sheets.
For example:

Name
John
Tom

Thanks in advance for the help!





"Peo Sjoblom" wrote:

I would personally use the autofilter for this and copy and paste filtered
list, there are some workarounds using index and small which can be seen here

http://tinyurl.com/56nv4


Regards,

Peo Sjoblom

"Mondie" wrote:

I am trying to create a function that will look up each occurence of the
Lookup value and return the corresponding name. Is this possible and if so,
how do I do it?

Apply autofilter, filter on the different Classes and then select and copy
and paste
The link I provided is a formula solution where you would put something like

=INDEX(Name_Range,SMALL(IF(Class_Range=2,ROW(Class _Range)),ROW(1:1)))

entered with ctrl + shift & enter and copied down


Regards,

Peo Sjoblom

"Mondie" wrote:

I have several lists to create. I tried looking at the reference you
supplied, but it returns an error message.

Here is the part of the table I am working with:
Class Name
1 02 John
2 03 Sally
3 05 Jim
4 02 Tom
5 03 Joe

What I need to do is put all of the "02's" on one sheet, the "03's" on
another sheet, and so on. I only need the names to post to the other sheets.
For example:

Name
John
Tom

Thanks in advance for the help!





"Peo Sjoblom" wrote:

I would personally use the autofilter for this and copy and paste filtered
list, there are some workarounds using index and small which can be seen here

http://tinyurl.com/56nv4


Regards,

Peo Sjoblom

"Mondie" wrote:

I am trying to create a function that will look up each occurence of the
Lookup value and return the corresponding name. Is this possible and if so,
how do I do it?