I'm using the below formula
<colgroup><col span="13"></colgroup><tbody>
</tbody>
OFFSET(H5,MATCH(INDEX(M6:M9,MATCH(C6,N6:N9,0)),H6:H9,0),MATCH(D5,I5:J5,0))
Could I do something in this bold, underlined area to add int he ability to find/sum more than one vertical value? For example in table (ER) cell B2 I'm looking for it to perform what it's doing now but also pick up TX vol. from (M)
End Result Chart (ER) | Model (M) | Basis Tab (BT) | ||||||||||
A | B | A | B | C… | A | B | C… | |||||
1 | 5/1/2019 | 1 | 5/1/2019 | 6/1/2019 | 1 | 5/1/2019 | 6/1/2019 | |||||
2 | OK | 510 | 2 | Total OK | 510 | 500 | 2 | Total OK | OK | |||
3 | TX | 690 | 3 | Total TX | 690 | 700 | 3 | Total TX | TX | |||
4 | NY | 300 | 4 | Total NY | 300 | 200 | 4 | Total NY | NY | |||
5 | Calif | 100 | 5 | Total CALIF | 100 | 50 | 5 | Total CALIF | Calif |
<colgroup><col span="13"></colgroup><tbody>
</tbody>
OFFSET(H5,MATCH(INDEX(M6:M9,MATCH(C6,N6:N9,0)),H6:H9,0),MATCH(D5,I5:J5,0))
Could I do something in this bold, underlined area to add int he ability to find/sum more than one vertical value? For example in table (ER) cell B2 I'm looking for it to perform what it's doing now but also pick up TX vol. from (M)