Hello all, my first time posting to this forum. I have watched a lot of the youtube videos and found a lot of good information in there. Specially for cleaning up my code later on. I appreciate your time, if your able to point me in the right direction. I may be asking the wrong question in regards to which function I wish to use, but I am sure someone may be able to push me in the right direction.
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
And this works well, But I wish to use these newly derived cell responses to drive additional data into other cells.
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.
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.