Using to and from zip codes to locate a single sheet

Originally Posted by NBVC

Can't you use the Hyperlink function and concatenate the first 3 letters of each code somehow to link to the proper sheet?

How do I accomplish that? I know how to hyperlink from any cell to pretty much anywhere, but I don't know how to deal with offering the user the opportunity to put in their origin and destination zips or how to have Excel decide which tab to then go to.

For instance, if it's shipping from Saint Louis to Chicago, Excel only needs two returns. One for a 3-digit origin/destination match, which would take the user to the right tab for pricing, or an error message saying one of the two zips used is not valid in our transportation area.