I will try to describe my sheet first, then pose the question related to it.

10+ columns with static data. Some of the data is not there yet.

This image show some of the data, But basically, you see how I had to create an origin and receiving catagory, then also a combination of the 2. Then from there individually assign a cost to each one. Is there a way to pair the to and from location, and assign a cost based on the pair, so that duplication of the data is not needed.

I hope that I articulated the data correctly, but not sure. I can see the final product of these formulas in my head, and I could fake it using power point to resemble the final product, but doing the formulas, I am lacking in this department. My most complex formula I am currently using is

Code:

`=VLOOKUP(B2,Chart,3,FALSE)`

I suck at articulatiing issues in text. Just looking for a push in the right direction. I don't mind looking up the answer, as long as I know what I am looking for. Thanks for any assistance.