Looks like you want to use a VLOOKUP function. As you didn't provide any
other details as to what you want done, I'm afraid I can't offer any other
help.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"steinerdf" wrote:

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