IF Statement Not Working Across Sheets

Hello,
That formula did not seem to work.

I have redone my example to try and get better results. I'm looking for a formula that will check all of column A and all of column B
in sheet 1 and if they match the row and column in sheet 2 then input the data from column C in sheet 1 to sheet 2.

Attached is another document with detailed notes.

Thanks,
Bdenn