VLOOKUP or INDEX for Multiple Table

[Mr Ray]

Trying to use VLOOKUP to pull data from 2 or multiplearrays. Only kicker is that I use multiple “Y’s” throughout each tableand “Y” is the value I use to lookup the correlating data.

Is this possible?



[TABLE="width: 561"]
<colgroup><col width="68" style="width: 51pt;" span="11"> <tbody>[TR]
[TD="width: 204, bgcolor: white, colspan: 3"]TABLE 1[/TD]
[TD="width: 68, bgcolor: white"] [/TD]
[TD="width: 204, bgcolor: white, colspan: 3"]TABLE 2[/TD]
[TD="width: 68, bgcolor: white"] [/TD]
[TD="width: 204, bgcolor: white, colspan: 3"]TABLE 4[/TD]
[/TR]
[TR]
[TD="bgcolor: #F8CBAD"]1[/TD]
[TD="bgcolor: #F8CBAD"]2[/TD]
[TD="bgcolor: #F8CBAD"]3[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #F8CBAD"]4[/TD]
[TD="bgcolor: #F8CBAD"]5[/TD]
[TD="bgcolor: #F8CBAD"]6[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #F8CBAD"]7[/TD]
[TD="bgcolor: #F8CBAD"]8[/TD]
[TD="bgcolor: #F8CBAD"]9
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]ROD[/TD]
[TD="bgcolor: white"]Y[/TD]
[TD="bgcolor: white"]RED[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]BLACK[/TD]
[TD="bgcolor: white"]23-Apr-19[/TD]
[TD="bgcolor: white"]OP[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]Y[/TD]
[TD="bgcolor: white"]13[/TD]
[TD="bgcolor: white"]98%[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]STAN[/TD]
[TD="bgcolor: white"]Y[/TD]
[TD="bgcolor: white"]BLUE[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]GREEN[/TD]
[TD="bgcolor: white"]29-Mar-19[/TD]
[TD="bgcolor: white"]CL[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]N[/TD]
[TD="bgcolor: white"]65[/TD]
[TD="bgcolor: white"]75%[/TD]
[/TR]
[TR]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white, colspan: 3"]EXTRACTED DATA[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #B4C6E7"]7[/TD]
[TD="bgcolor: #B4C6E7"]1[/TD]
[TD="bgcolor: #B4C6E7"]5[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]Y[/TD]
[TD="bgcolor: yellow"] [/TD]
[TD="bgcolor: yellow"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]N[/TD]
[TD="bgcolor: yellow"] [/TD]
[TD="bgcolor: yellow"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1094486-vlookup-different-table-array.html#post5261328

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.