Dear Excel Community,
Currently I have a parameters table that looks like this.
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
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
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
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.
Type | AB | A | AB | A | AB | A | AB | A | AB | A | AB | A |
Dispatch | 50 | 10 | 50 | 10 | 50 | 10 | 50 | 10 | 50 | 2 | 10 | 2 |
Days | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 |
Months | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 |
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
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
Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 | |
A | ||||||||||||
AB |
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
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!