Like a VLOOKUP, but returning multiple values (for multiple matches)

Hi,
I'm undertaking a matching excercise, matching employee preferences for new roles to available roles.

I need a formula that effectively generates a shortlist of candidates, finding matches in an array.

I have manually returned the values I would want returned to provide an example (see row 20) , but obviously I need a forumla or macro that c an do this.

If you have any suggestions or advice, it would be much appreciated.

Thanks,

Ben