How to incorporate IF and VLOOKUP formula to a Match Index Formula?

I've a Match Index formula:

FORMULA = INDEX(D:D,MATCH(1,INDEX((F2=E:E)*(D2=B:B),0),0))

And I want to incorporate this condition

If value of (vlookup(A2, D:F, 3, FALSE) is GREATER than zero(0) do FORMULA

If EQUAL or LESS than zero(0) go to next row then if EQUAL or LESS than zero again go to next row

If finally in the last row it gives GREATER than zero then do the FORMULA

Is this possible?