Issue using Index/Match to pull multiple occurrences of "Match" criteria

[aridfriedman]

Hi

I am attempting to use the Index/Match to match each instance of "Person Responsible" that is mentioned in Column D (D:D) (All tab), which have been pulled from the 'All Tab', and pull subsequent column names to create individualized lists on other tabs. The issue is that the Index/Match formula is only matching the 1st instance of the "Name" and not moving on to the subsequent matches in the search array.

Is a ROW function needed to help determine when to move on? I'm modestly proficient with excel and I'm sure it's not that hard, but any help would be greatly appreciated.

I have attached a sample spreadsheet for any possible assistance.

Thank you in advance.