Well I've added a few more values now totaling 14...

I tried this and I get a "false" AND then the correct answer, obviously because the correct value is in the second IF statement.

=IF(C5="ATV Sport",J5*9.5%,IF(C5="ATV Utility",J5*9.5%,IF(C5="Cruiser",J5*9.8%,IF(C5="Cr uiser Touring",J5*9.8%,IF(C5="Dual Sport",J5*9.8%,IF(C5="MX",J5*9.5%,IF(C5="Offroad", J5*9.5%)))))))&IF(C5="PWC",J5*9.5%,IF(C5="Scooter" ,J5*9.8%,IF(C5="Standard",J5*9.8%,IF(C5="Sport",J5 *9.8%,IF(C5="Sport Touring",J5*9.8%,IF(C5="Trailer",J5*9.5%,IF(C5="UT V",J5*9.5%)))))))

The I tried this, but I get "formula contains an error"

=LOOKUP(C5,{"ATV Sport","ATV Utility","Cruiser","Cruiser Touring","Dual Sport","MX","Offroad","PWC","Scooter","Standard"," Sport","Sport Touring","Trailer","UTV"},{J5*9.5%,J5*9.5%,J5*9.8% ,J5*9.8%,J5*9.8%,J5*9.5%,J5*9.5%,J5*9.5%,J5*9.8%,J 5*9.8%,J5*9.8%,J5*9.8%,J5*9.5%,J5*9.5%})

I'm stumped.

-T