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

[ben.fish]

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

 

[Armando Montes]

Perhaps this:
http://www.mrexcel.com/forum/showthread.php?t=487925&highlight=lookup+multiple+results

 

[ben.fish]

Thanks for your quick response. Not quite what I needed. Is there a way to upload a file / screenshot?