View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ripper Ripper is offline
external usenet poster
 
Posts: 25
Default Vlookup Return Multiple Values

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.



--
Thanks As Always
Rip