I would like to pull a sub-list from Col B when Col C matches specific criteria and when Col D matches multiple specific Critiria and put the sublist in Col A.
Example
ColA | ColB | ColC | ColD
a | a | 1 | s
c | b | 2 | t
e | c | 1 | u
g | d | 2 | v
| e | 1 | w
| f | 2 | s
| g | 1 | u
| h | 2 | w
where ColC must match 1 and ColD must match s, u, or w
Any help would be greatly appreciated.
Attached a sample to play with.
Best,
ExcelFalcon
Bookmarks