Filter out data based on range of cell values using formula

[Glasgowsmile]

I have data like below and I'm trying to use a filter formula to remove certain entries based on their email address:

I'm adding the emails I want to filter out into row E but the formula below isn't removing them from the original data set. What am I missing?

Formula:

=FILTER(A:D, D:D<>E:E)

Sample:

First Name

Last Name

Role

Email

 

[Fluff]

How about

=FILTER(A2:D1000,(D2:D1000<>"")*(ISNA(MATCH(D2:D1000,E2:E20,0))))