IF Statement Not Working Across Sheets

Hello All,
I need some help with a nested if statement.

I'm trying to pull a cells data from one sheet to another if it meets 2 requirements.
1, If Column A states "RF Module 1" and 2, If Column B states "RF Drive Power" to pull Column C.

Excel Sheet 1.PNG

This formula is working correctly if I keep it on the same sheet. But if I write the formula on a different sheet (which I need to do) I get a value error.

Formula that works: =IF(A180:A181=A180,IF(B180:B181=B180,C180))

Formula that does not work: =IF(Sheet1!A180:A181=Sheet2!B1,IF(Sheet1!B180:B181=Sheet2!A2,Sheet1!C180))
This gives me a #Value! error.

Is there a better way to do this or is something wrong?

Thanks,
Bdenn