Trying to use VLOOKUP to pull data from 2 or multiplearrays. Only kicker is that I usemultiple “Y’s” throughout each table and “Y” is the value I use to lookup thecorrelating data. Is this possible? TABLE 1 | TABLE 2 | TABLE 3 | ||||||||
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 |