I have a spreadsheet that is calculating total cost based on the region of
the country and total weight of a project that the user selects.

The whole story is that a user selects a region of the USA from a drop down
box. Then the user enters in the estimated total weight (lbs) for the
project.

The function I am looking for looks for the region, then when selected, it
looks at a set of values for that region, doing a couple calculations based
on 5 cells information, then producing a result. The weight entered is
involved in the calculation.

Email me any questions or solutions to