Hi

Thanks for all your help, yes I have converted the IDs to text.

Can you help me rewrite these two TRUE/FALSE formulas for a match scenario?

=IF('Cost Summary'!H2=0,0,IF(AND('Cost Summary'!H2>=1,'Cost Summary'!H2<=6),-2,IF('Cost Summary'!H2>6,-3,Select Bridge Length)))

=IF('Cost Summary'!J2="Nominal",0,IF('Cost Summary'!J2="Minor",-1,IF('Cost Summary'!J2="Moderate",-2,IF('Cost Summary'!J2="Substantial",-3,"Select Earthworks Allowance"))))

Thanks again!