Lookup value across multiple columns and rows

I

ImagineActuality

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

Is there an easy way to lookup the object (for example, Bananas) an
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! :

+-------------------------------------------------------------------
|Filename: LookupTable.png
|Download: http://www.excelbanter.com/attachment.php?attachmentid=332
|Filename: WhatIWant.png
|Download: http://www.excelbanter.com/attachment.php?attachmentid=333
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Autonumber with Prefix and Category Grouping 3
Need help with average/lookup formula 2
vertical and horizontal lookup? 1
Dropdownlist and Vlookup 6
how to copy and paste value from one sheet to another 4
Looking up other sheet for value X depnding on sheet Y and Z colums 1
Condtional Formatting or LOOKUP ? 1
Formual to lookup sumtotal from data with spaces 3

Top