Match 2 Seperate Column Values on worksheet to 2 values on another sheet,display offset

I have not bumped into one this hard in a while. I am missing something simple but Ill try and explain, I have a worksheet that autopopulates employee data. I want to match two columns of data with a corresponding rate sheet and provide the corresponding billing rate. So based on Bob Being A PM/IW how can I generate his billing rate? Sheet2 is my data base. I keep trying the INDEX(C1:C4,(Match(1,(B2=Sheet2!A1:A4)*(C2=Sheet2!B1:B4),0)) but Ive been getting stumped by this for longer than I care to admit. HELP is the word. I can get it done with nested Ifs but I know there is a simpler solution.
Thanks in Advance.

Sheet 1
------A------B--------C----------D------E
1--NAME---TITLE---SUBTITLE----HRS----Billing
2--Bob------PM------IW----------8------???
3--Sue------PM------SS----------9------???
4--Jack------SP------PF----------5------???


Sheet 2
-----A-------- B----------C
1--TITLE----SUBTITLE----RATE
2--PM--------IW---------75
3--SP--------IW---------98
4--PM--------SS---------84
5--SP--------PF---------35

try this

=SUMPRODUCT(--(B2=Sheet2!$A$2:$A$5),--(C2=Sheet2!$B$2:$B$5),Sheet2!$C$2:$C$5)

and copy down

Works perfectly. I didn't realize the sum product pulled up a single digit value for a hit. Someone still needs to explain the "--" to me in the logic. Laymans terms if possible.

Originally Posted by runnyrunnerton

Works perfectly. I didn't realize the sum product pulled up a single digit value for a hit. Someone still needs to explain the "--" to me in the logic. Laymans terms if possible.

The double negative "--" turns TRUE and FALSE into 1's an 0's
1. --(B2=Sheet2!$A$2:$A$5)
2. --{TRUE;FALSE;TRUE;FALSE}
3. {1;0;1;0}