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 1		TABLE 2		TABLE 4
1	2	3		4	5	6		7	8	9
ROD	Y	RED		BLACK	23-Apr-19	OP		Y	13	98%
STAN	Y	BLUE		GREEN	29-Mar-19	CL		N	65	75%
				EXTRACTED DATA
				7	1	5
				Y
				N

<colgroup><col width="68" style="width: 51pt;" span="11"> <tbody> </tbody>

 

[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.