I'm using the below formula
[TABLE="width: 1066"]
<colgroup><col span="13"></colgroup><tbody>[TR]
[TD="colspan: 2"]End Result Chart (ER)[/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 2"]Model (M)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 2"]Basis Tab (BT)[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C…[/TD]
[TD][/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C…[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD]6/1/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD]6/1/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]OK[/TD]
[TD]510[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Total OK[/TD]
[TD]510[/TD]
[TD]500[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Total OK[/TD]
[TD]OK[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TX[/TD]
[TD]690[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Total TX[/TD]
[TD]690[/TD]
[TD]700[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Total TX[/TD]
[TD]TX[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]NY[/TD]
[TD]300[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]Total NY[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]Total NY[/TD]
[TD]NY[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Calif[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]Total CALIF[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]Total CALIF[/TD]
[TD]Calif[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="width: 1066"]
<colgroup><col span="13"></colgroup><tbody>[TR]
[TD="colspan: 2"]End Result Chart (ER)[/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 2"]Model (M)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD="colspan: 2"]Basis Tab (BT)[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C…[/TD]
[TD][/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C…[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD]6/1/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]5/1/2019[/TD]
[TD]6/1/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]OK[/TD]
[TD]510[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Total OK[/TD]
[TD]510[/TD]
[TD]500[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Total OK[/TD]
[TD]OK[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TX[/TD]
[TD]690[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Total TX[/TD]
[TD]690[/TD]
[TD]700[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Total TX[/TD]
[TD]TX[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]NY[/TD]
[TD]300[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]Total NY[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]Total NY[/TD]
[TD]NY[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Calif[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]Total CALIF[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]Total CALIF[/TD]
[TD]Calif[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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)