Lookup value across multiple columns and rows
 

I've got a bunch of containers (listed in Column A) that hold various objects (listed across Columns B, C and D). Each container may hold several different objects, and the same object may be found in several containers.

Is there an easy way to lookup the object (for example, Bananas) and display a list of containers that the object is in?

See attached screenshots:
- My lookup table
- What I want to display with Excel formulas

Thanks! :)