Excel Formula Multiple Criteria Lookup

lilyhandrick 

Your question is open to multiple interpretations.

Taking the simplest interpretation, put this formula in Sheet 1, Cell C1

=IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!B1=Sheet2!B1),Sheet2!C1,"No match")

But what you wrote: 

I need a formula that says if this value in column A Sheet 1 equals a value in Column A Sheet 2, and the value in column B Sheet 1 equals a value in Column B Sheet 2 then ...

also could be interpreted to mean if a value anywhere in column A of sheet 1 equals a value anywhere in column A of Sheet 2...