Combine multiple INDEX/Match conditions

[rlsublime]

Hello: I have attached the sample file that I am working. I currently have an if statement in the F col under % comp billed. I am trying to create a match index statement to match the table from O1 to V5 with the comp code entered in the A col as well as the *** billing code entered in the C col. is there a way to insert a statement to combine this. the current if statement that I have entered generates an error when the comp code is not = to 1. Thanks in advance for your help.

Pls see file attachedtest3.xlsx

[lporter77]

Insert the formula below into F8 and copy down

=VLOOKUP($A8,$R$2:$V$5,MATCH($C8,$S$1:$V$1,0)+1,1)

[rlsublime]

Thanks a lot that solved the problem. Cheers