How to combine IF, VLOOKUP and MATCH?

How do you combine IF, LOOKUP and MATCH to come up with a formula in these conditions

If A7 is equal in any rows in sheet 2 column A, B6 is equal to any rows in sheet 2 column B, and A3 is equal to any rows in C, then return the value of sheet 2 column D.


Thanks!