VLookup to display multiple results?

Hello,

So basically I have 3 different spreadsheets which have a column that shows a list of names attached to open assignments. I want to create a separate tab, which I can input a users name and have a column that displays all their open assignments. I was thinking a VLOOKUP might work, but obviously that will only show me the first instance of a users name & not any subsequent instances.

I also played around w/ using a macro & VBA w/ the advanced filter. Below is what I had created so far:

Please Login or Register  to view this content.

It runs the first bit of code just fine, however, when it tries to apply the filter to the second sheet, it spits back an error that I just can't seem to troubleshoot. Anyone have any suggestions or tips?

Personally, I would add a helper column that identifies the name, a delimiter character (like ".", "-", or "|"), and then a sequential number. Then you can do a VLOOKUP for each instance up to the count of the number of duplicates. So, for example, if Joe has 3 open assignments, you want to look up Joe-1, Joe-2, and Joe-3.

If you want help with specific formulas, please attach a sample file.