Okay, your formula above does not match what you have in the example workbook.
Try this in H2, based on the sample you provided. Your problem was that the IF had no means of "escape" to the correct answer. I reversed it and it seems to work. Note that I separated the individual lookups into cells H4:H9, then combined the IF formula in H12, then substituted those individual formulas into H11.
=IF(NOT(ISNA(VLOOKUP($C2&$H$1,shipschd!$C$2:$D$40,2,FALSE))),VLOOKUP($C2&$H$1,shipschd!$C$2:$D$40,2,FALSE),IF(NOT(ISNA(VLOOKUP($C2&$H$1,shipschd!$F$2:$G$40,2,FALSE))),VLOOKUP($C2&$H$1,shipschd!$F$2:$G$40,2,FALSE),IF(NOT(ISNA(VLOOKUP($C2&$H$1,shipschd!$F$2:$G$38,2,FALSE))),VLOOKUP($C2&$H$1,shipschd!$F$2:$G$38,2,FALSE),IF(NOT(ISNA(VLOOKUP($C2&$H$1,shipschd!$F$2:$G$38,FALSE))),VLOOKUP($C2&$H$1,shipschd!$F$2:$G$38,FALSE),IF(NOT(ISNA(VLOOKUP($C2&$H$1,shipschd!$I$2:$J$38,2,FALSE))),VLOOKUP($C2&$H$1,shipschd!$I$2:$J$38,2,FALSE),VLOOKUP($C2&$H$1,shipschd!$I$2:$J$38,2,FALSE))))))
________
AEROSTAR