Vlookup Return Multiple Values

[Ripper]

I have a table that lists any modifications to a test in 1 sheet by the
following criteria:
A B C
LocID Modification TestType

I am trying to make a list of all the students mods and need them returned
in Sheet 2 where I have a list of all my Students with their LocID. When I
use VLookup, which I love, I only get the first match on LocID. I need a
list of them all. Is there a way to accomplish this? It doesn't really
matter if they are in a list after the student or all combined into 1 cell.

 

[akphidelt]

Yea, there really isn't any formulas that return multiple results across
multiple cells. The best thing to do is create a filter or a pivot table...
that would allow you to pick an item and show all results that relate to the
item chosen.

 

[Dave Peterson]

I'd use a user defined function.

How do you want to display those results? In one cell, but separated by
commas? In separate cells???

If you want a single cell:

http://groups.google.co.uk/group/mi...author:peterson&rnum=1&hl=en#db28f1ba868980a8

or

http://snipurl.com/24yfb (first post in the thread)


If you wanted separate cells (horizontal or veritical), take a look here:

http://groups.google.co.uk/group/mi...roup:*excel*+author:peterson#b5467b485b0a4f4d

or

http://snipurl.com/24yf3

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Pete_UK]

Give some detail of how your data is laid out in Sheet1 and how you
would like the modifications to be shown in it.

Pete