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