I need to find the first instance of a named range that occurs in a table and return another value from that table on the same row.
Two Named Ranges Cat1 and Cat2
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Cat 1[/TD]
[TD="width: 64"]Cat 2[/TD]
[/TR]
[TR]
[TD]Type A[/TD]
[TD]Type E[/TD]
[/TR]
[TR]
[TD]Type B[/TD]
[TD]Type F[/TD]
[/TR]
[TR]
[TD]Type C[/TD]
[TD]Type G[/TD]
[/TR]
[TR]
[TD]Type D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need to search Column A in this table and return the first time something from Cat1 appears and return the value from column B that corresponds to the match. I have looked through many examples of Index Match but I have not been able to find this scenario.
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Type[/TD]
[TD]Volume[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Type E[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Type G[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Type C[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Type F[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Type F[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Type F[/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Type F[/TD]
[TD="align: right"]800[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Type F[/TD]
[TD="align: right"]900[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]Type A[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Type G[/TD]
[TD="align: right"]1100[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]Type G[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]Type G[/TD]
[TD="align: right"]1300[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]Type G[/TD]
[TD="align: right"]1400[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]Type G[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Two Named Ranges Cat1 and Cat2
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Cat 1[/TD]
[TD="width: 64"]Cat 2[/TD]
[/TR]
[TR]
[TD]Type A[/TD]
[TD]Type E[/TD]
[/TR]
[TR]
[TD]Type B[/TD]
[TD]Type F[/TD]
[/TR]
[TR]
[TD]Type C[/TD]
[TD]Type G[/TD]
[/TR]
[TR]
[TD]Type D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need to search Column A in this table and return the first time something from Cat1 appears and return the value from column B that corresponds to the match. I have looked through many examples of Index Match but I have not been able to find this scenario.
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Type[/TD]
[TD]Volume[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Type E[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Type G[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Type C[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Type F[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Type F[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Type F[/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Type F[/TD]
[TD="align: right"]800[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Type F[/TD]
[TD="align: right"]900[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]Type A[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Type G[/TD]
[TD="align: right"]1100[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]Type G[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]Type G[/TD]
[TD="align: right"]1300[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]Type G[/TD]
[TD="align: right"]1400[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]Type G[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]