single lookup value with multiple results

[aramancam]

I'm trying to find a way to look up a single value in one column which has
multiple results in the next column.

 

[Peo Sjoblom]

Here's an example

http://www.nwexcelsolutions.com/advanced_function_page.htm

look at number 6