index match with if statement

Hello,

Ive tried many diffent index match functions together with an IF statement, but I cant make it work, any one that can help me with this?

My data looks like this;

A B C D
1 Data1 Data2 Data3 Data4
2 0 5 15 1
3 5 819 -7 0
4 3 7 10 0
5 -999 10 4 0
6 7 11 15 0
7 0 12 4 0
8 5 819 -999 0

I want to use an IF statment too sort and filter my data: =IF(AND(D2=0;C2>-5;B2<>-819);A2)

The Intension with index / match is top be able to generate a list like bellow;

E F G H
1 Data1 Data2 Data3 Data4
2 3 7 10 0
3 7 11 15 0
4 0 12 4 0

So with the if formula I want to filter away rows and than be able to generate a list with all true values with out rows inbetween my values.

Thanks in advance!

Thanks! Worked great :-)