Dear Excel Community,
Currently I have a parameters table that looks like this.
[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Type[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[/TR]
[TR]
[TD="class: xl63"]Dispatch[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]Days[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[/TR]
[TR]
[TD="class: xl63"]Months[/TD]
[TD="class: xl65, align: right"]Jan-18[/TD]
[TD="class: xl65, align: right"]Feb-18[/TD]
[TD="class: xl65, align: right"]Mar-18[/TD]
[TD="class: xl65, align: right"]Apr-18[/TD]
[TD="class: xl65, align: right"]May-18[/TD]
[TD="class: xl65, align: right"]Jun-18[/TD]
[TD="class: xl65, align: right"]Jul-18[/TD]
[TD="class: xl65, align: right"]Aug-18[/TD]
[TD="class: xl65, align: right"]Sep-18[/TD]
[TD="class: xl65, align: right"]Oct-18[/TD]
[TD="class: xl65, align: right"]Nov-18[/TD]
[TD="class: xl65, align: right"]Dec-18[/TD]
[/TR]
</tbody>[/TABLE]
How do I utilize index match function to return the dispatch values based on their types onto another table in another sheet that looks like this
[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 64, align: right"]Jan-18[/TD]
[TD="class: xl65, width: 64, align: right"]Feb-18[/TD]
[TD="class: xl65, width: 64, align: right"]Mar-18[/TD]
[TD="class: xl65, width: 64, align: right"]Apr-18[/TD]
[TD="class: xl65, width: 64, align: right"]May-18[/TD]
[TD="class: xl65, width: 64, align: right"]Jun-18[/TD]
[TD="class: xl65, width: 64, align: right"]Jul-18[/TD]
[TD="class: xl65, width: 64, align: right"]Aug-18[/TD]
[TD="class: xl65, width: 64, align: right"]Sep-18[/TD]
[TD="class: xl65, width: 64, align: right"]Oct-18[/TD]
[TD="class: xl65, width: 64, align: right"]Nov-18[/TD]
[TD="class: xl65, width: 64, align: right"]Dec-18[/TD]
[/TR]
[TR]
[TD="class: xl66"]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]AB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
At the moment, the formula I have just gives me the same values as the first table under the dispatch row regardless if it is A or AB?
Thank you all in advance!
Currently I have a parameters table that looks like this.
[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Type[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[TD="class: xl64, width: 64"]AB[/TD]
[TD="class: xl64, width: 64"]A[/TD]
[/TR]
[TR]
[TD="class: xl63"]Dispatch[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]Days[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]31[/TD]
[/TR]
[TR]
[TD="class: xl63"]Months[/TD]
[TD="class: xl65, align: right"]Jan-18[/TD]
[TD="class: xl65, align: right"]Feb-18[/TD]
[TD="class: xl65, align: right"]Mar-18[/TD]
[TD="class: xl65, align: right"]Apr-18[/TD]
[TD="class: xl65, align: right"]May-18[/TD]
[TD="class: xl65, align: right"]Jun-18[/TD]
[TD="class: xl65, align: right"]Jul-18[/TD]
[TD="class: xl65, align: right"]Aug-18[/TD]
[TD="class: xl65, align: right"]Sep-18[/TD]
[TD="class: xl65, align: right"]Oct-18[/TD]
[TD="class: xl65, align: right"]Nov-18[/TD]
[TD="class: xl65, align: right"]Dec-18[/TD]
[/TR]
</tbody>[/TABLE]
How do I utilize index match function to return the dispatch values based on their types onto another table in another sheet that looks like this
[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 64, align: right"]Jan-18[/TD]
[TD="class: xl65, width: 64, align: right"]Feb-18[/TD]
[TD="class: xl65, width: 64, align: right"]Mar-18[/TD]
[TD="class: xl65, width: 64, align: right"]Apr-18[/TD]
[TD="class: xl65, width: 64, align: right"]May-18[/TD]
[TD="class: xl65, width: 64, align: right"]Jun-18[/TD]
[TD="class: xl65, width: 64, align: right"]Jul-18[/TD]
[TD="class: xl65, width: 64, align: right"]Aug-18[/TD]
[TD="class: xl65, width: 64, align: right"]Sep-18[/TD]
[TD="class: xl65, width: 64, align: right"]Oct-18[/TD]
[TD="class: xl65, width: 64, align: right"]Nov-18[/TD]
[TD="class: xl65, width: 64, align: right"]Dec-18[/TD]
[/TR]
[TR]
[TD="class: xl66"]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]AB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
At the moment, the formula I have just gives me the same values as the first table under the dispatch row regardless if it is A or AB?
Thank you all in advance!