KenGranger
New Member
- Joined
- Feb 23, 2018
- Messages
- 2
I have an expense form that includes a mileage chart. I have "From Branch" and "To Branch" columns, each of which uses the same list of branches as data validation.
[TABLE="width: 332"]
<tbody>[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]Mileage[/TD]
[/TR]
[TR]
[TD]Main[/TD]
[TD]Ditch Road[/TD]
[TD] 12.51[/TD]
[/TR]
[TR]
[TD]The Other Branch[/TD]
[TD]Main[/TD]
[TD]16.86[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
I have a mileage chart matrix showing approved mileage between the bank branches. I want to use the values in the From and To columns to populate the approved mileage from the following matrix. Assume "Main" in the vertical list is cell A2, and "Main" in the horizontal list is cell B1. The mileage entered in the rows above should be the values shown in bold below.
I'm a relative novice with Excel, and this has be stymied. Any suggestions would be appreciated. I've looked around here a bit and haven't found exactly what I'm looking for. If this has already been answered, please accept my apologies and show me the path of enlightenment. Thanks.
[TABLE="width: 360"]
<tbody>[TR]
[TD] [/TD]
[TD]Main[/TD]
[TD]Ditch Road[/TD]
[TD]The Other Branch[/TD]
[TD]Another Brance[/TD]
[TD]Last Branch[/TD]
[/TR]
[TR]
[TD]Main[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]12.51[/TD]
[TD="align: right"]16.86[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]12.01[/TD]
[/TR]
[TR]
[TD]Ditch Road[/TD]
[TD="align: right"]12.51[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]9.16[/TD]
[TD="align: right"]12.15[/TD]
[TD="align: right"]33.96[/TD]
[/TR]
[TR]
[TD]The Other Branch[/TD]
[TD="align: right"]16.86[/TD]
[TD="align: right"]9.16[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]16.55[/TD]
[TD="align: right"]27.59[/TD]
[/TR]
[TR]
[TD]Another Branch[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]12.15[/TD]
[TD="align: right"]16.55[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]12.33[/TD]
[/TR]
[TR]
[TD]Last Branch[/TD]
[TD="align: right"]12.01[/TD]
[TD="align: right"]33.96[/TD]
[TD="align: right"]27.59[/TD]
[TD="align: right"]12.33[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]
[TABLE="width: 332"]
<tbody>[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]Mileage[/TD]
[/TR]
[TR]
[TD]Main[/TD]
[TD]Ditch Road[/TD]
[TD] 12.51[/TD]
[/TR]
[TR]
[TD]The Other Branch[/TD]
[TD]Main[/TD]
[TD]16.86[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
I have a mileage chart matrix showing approved mileage between the bank branches. I want to use the values in the From and To columns to populate the approved mileage from the following matrix. Assume "Main" in the vertical list is cell A2, and "Main" in the horizontal list is cell B1. The mileage entered in the rows above should be the values shown in bold below.
I'm a relative novice with Excel, and this has be stymied. Any suggestions would be appreciated. I've looked around here a bit and haven't found exactly what I'm looking for. If this has already been answered, please accept my apologies and show me the path of enlightenment. Thanks.
[TABLE="width: 360"]
<tbody>[TR]
[TD] [/TD]
[TD]Main[/TD]
[TD]Ditch Road[/TD]
[TD]The Other Branch[/TD]
[TD]Another Brance[/TD]
[TD]Last Branch[/TD]
[/TR]
[TR]
[TD]Main[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]12.51[/TD]
[TD="align: right"]16.86[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]12.01[/TD]
[/TR]
[TR]
[TD]Ditch Road[/TD]
[TD="align: right"]12.51[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]9.16[/TD]
[TD="align: right"]12.15[/TD]
[TD="align: right"]33.96[/TD]
[/TR]
[TR]
[TD]The Other Branch[/TD]
[TD="align: right"]16.86[/TD]
[TD="align: right"]9.16[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]16.55[/TD]
[TD="align: right"]27.59[/TD]
[/TR]
[TR]
[TD]Another Branch[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]12.15[/TD]
[TD="align: right"]16.55[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]12.33[/TD]
[/TR]
[TR]
[TD]Last Branch[/TD]
[TD="align: right"]12.01[/TD]
[TD="align: right"]33.96[/TD]
[TD="align: right"]27.59[/TD]
[TD="align: right"]12.33[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]