| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return multiple values in a list?
I have a list that has two columns.. In column A is a list of containers. in
column B is a list of components. The containers in A can have multiple components in them i.e. Cont Comp 1 xyz 1 ABC 1 DEF 2 aaa 3 bbb 3 baa how can I get a list of every component that appears in a given container? Vlookup returns a component in a given box, but not EVERY component? ideas anyone? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if multiple values same/others different, return true | Excel Discussion (Misc queries) | |||
| Help needed replacing multiple cells from a list of values. | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| How to look up a value in a list and return multiple corresponding | Excel Discussion (Misc queries) | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
Threaded Mode
