| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return Multiple values using VLookup? | Excel Worksheet Functions | |||
| vlookup one value and return multiple values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Threaded Mode
