[SOLVED] Working out a Gross Margin value from two locations

Good morning all,

I am struggling with the following, if you can help:

In the attached test file you'll be able to see that I have data pulling through to the Cont 1 tab based off the contractor's name. From this my other columns populate with vlookup data from the Starters tab.

My issue is that with the GM (column K) my formula looks to the starters tab to calculate the pay and charge rate to figure out the gross margin, however, as there are multiple categories for pay and charge I need the formula to be able to look past a zero value if found first and look to the next pay category.

So at present it says based on a match of the contractor's name, bring me Y2-X2*5. On the Starters tab that value is zero. I need the formula to be able to then see that it is zero and move on to AA2-Z2*5.

Is this possible?

Thank you all for your help.

please recheck your attached file
The Contractor name not found in Starters File and the GM is column L of IT sheet

k6=SUMPRODUCT(INDEX(Starters!$X$2:$AA$11,MATCH($F$6,Starters!$C$2:$C$11,0),)*{-1,1,-1,1})
Try this and copy towards down

=SUMPRODUCT(INDEX(Starters!$X$2:$AA$11,MATCH($F$6,Starters!$C$2:$C$11,0),)*{-1,1,-1,1})/SUMPRODUCT(INDEX(Starters!$X$2:$AA$11,MATCH($F$6,Starters!$C$2:$C$11,0),)*{1,0,1,0})
my be this will work