Search and copy based on partial text match

Hi everyone!

I have a list in Column A with 1000 Rows, all are texts. In D1 and E1 I have two texts, which would be the search criterias.
I'd like to search the Column A, if the values in D1 and E1 are part of a row simultaneously but it can be only partial match. I cannot use VLOOKUP because it can give multiple results. The results should be listed in a separate sheet. Here is an example:

Column A
ABD_DDT_VitaminB12
ABD_dka_VitaminB2
ABD_dka_VitaminB2_version2
DAT_kft_VItaminB2

And I'd like to see in a separate sheet only the rows which contains "ABD" and "VitaminB2"

Thank you!

Hi,

can be done with an advanced filter with or whitout any code …

Try this:

Please Login or Register  to view this content.

Try on a copy 1st. Copies to Sheet2.

Please Login or Register  to view this content.

Thanks! The first one works perfectly! You made my day :D