Perhaps these, respectively:
=IFERROR(LOOKUP(INDEX('Cost Summary'!H:H,MATCH(A2,'Cost Summary'!A:A,0)),{0,6,7},{0,-2,-3}),"Select Bridge Length")
=IFERROR(LOOKUP(INDEX('Cost Summary'!J:J,MATCH(A2,'Cost Summary'!A:A,0)),{"Minor","Moderate","Nominal","Su bstantial"},{-1,-2,0,-3}),"Select Earthworks Allowance")
|