Help - Formula that changes after selecting from a drop-down box and giving the results?

Hi,

I have a task to calculate whether a dimension of a cargo (L x W x H) can be accepted or not accepted
I think the formula should be =IF(cell<=cell ,"Accepted","Not Accepted")

However, as this dimension needs to be checked for multi places with different limitations of based on the overlength x overwidht x overheight dimensions (dimensions exceeding the box)

Now my questions is whether there is a way on how I can check for acceptance if I use a drop down box of ports 1-59 that will automatically result with as accepted or not accepted if the overlength x overwidht x overheight dimensions are within or exceeding the ports limitations


any help will be highly appreciated, I have provided my worksheet attached

Any advise please?

the document you attached seems pretty complicated and may require professional knowledge of whatever industry you are using it for.

try posting a small, simple sample worksheet with one or two examples. that will make it easier for people to answer