Pay Scale with bonuses

[raymondcg]

So here is my issue

I want to be able to send this out to my crew to allow them to predict what pay they will get. I have attached a sheet with values and fields. I would like to have them be able to pick from the drop down and have the values populate and give a total. All values are on sheet 2 and the drop down lists are on sheet 1. Any help would be great. I tried the IF formula but I am not the best at this stuff.

Thanks in advance

[samba_ravi]

d3=INDEX(Sheet2!D3:H18,MATCH(Sheet1!C2,Rank,0),MATCH(Sheet1!C3,IPC,0))
d4=VLOOKUP(C4,Sheet2!B20:C23,2,0)
d5=VLOOKUP(C5,Sheet2!E20:F23,2,0)
d6=HLOOKUP(C6,Sheet2!C25:J27,2,0)
d7=HLOOKUP(C7,Sheet2!C25:J27,3,0)*D5

[raymondcg]

Thanks for the Help.

That is just what I needed and would have taken me years