Creating a new list with multiple options?

[BigPapaMurf]

I've got a table created ("table a" in attached sample) where I extract and create new lists (like tables b and c) based on a single requirement ("type" column). What I'd like to do is create "table d" where the new list pulls multiple "types" from "table a". Specifically, I want the new table to pull 4 different types to create a new list. How do I add those 3 additional requirements?


Here is the current formula (table b example)

=IFERROR(INDEX($C$8:$C$17,SMALL(IF($D$8:$D$17=$G$7,ROW($C$8:$C$17)),ROW(1:1))-7,1),"")

[truk2]

When I try to open your sample workbook, it asks for my email login and then denies access. Could you please check your document security and then share the example again?

Secondly, would you be happy with an array formula spill (current Office 365 only), or a vba solution?

[BigPapaMurf]

Array probably, Attachment updated in original post

[BigPapaMurf]

if that one doesn't work, try this one

[bebo021999]

Try in M8:

Please Login or Register  to view this content.

Copy to N8, change $C:$C to $E:$E

[BigPapaMurf]

that works! thanks

[Bo_Ry]

With MS 365 Please try

=FILTER(FILTER($C$8:$E$17,COUNTIF(M7,"*"&$D$8:$D$17&"*")),{1,0,1})

or for type more than 10

=FILTER(FILTER($C$8:$E$17,ISNUMBER(SEARCH($D$8:$D$17&",",SUBSTITUTE(M7&",",")",)))),{1,0,1})

[BigPapaMurf]

Thank you!