Freight Rate Repository

Without a sample workbook, the best I can do is outline how I would do it.

You obviously have a table of cities and the cost between cities. I can envision this table being in one of two formats:

Houston - Dallas - rate
Houston - Brownsville - rate
Houston - San Antonito - rate
etc.

Or have a bunch of cities going down the rows and the same cities going across the columns and the rates being at the intersection.

This would impact the design of the lookup. In the first, you would need a helper cell to combine the origin and destination. In the second you can use Match Index. In the first, you would enter the origin and destination and make a combined key out of them and look up based on that key.

Then there is the matter of data validation. That is you would have to come up with a list of unique city names to use in dropdown lists. Pivot tables may come in handy to get the list.

Then what? After you get the cities and the rates, what will you do with them?

TimdeBeer welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.