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!