| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup to multiple rows and columns | Excel Worksheet Functions | |||
| Using lookup function on multiple rows and columns | Excel Worksheet Functions | |||
| Find a value Using a lookup table multiple columns and rows | Excel Worksheet Functions | |||
| Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Hybrid Mode
