Looking for a formula to look up based on Column and Row but with different sized arrays

[thekaoboy]

For example, in the below table, I would like a formula that would return "Mary" for Green 3, or "Jane" for Red 5. You sunk my battleship!

I tried a combination of HLOOKUP, VLOOKUP, INDEX, and MATCH but I get tripped up because the row arrays are different sizes.

Thanks all.

Name	Color	1	2	3	4	5
Jane	Red					x
Tom	Red		x	x	x
Sam	Blue	x	x	x	x	x
Lisa	Green	x	x
Mary	Green			x	x
Jane	Green					x
Lisa	Yellow				x	x
Gary	Yellow	x	x	x

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Color	1	2	3	4	5
2	Jane	Red					x		Green	3	Mary
3	Tom	Red		x	x	x			Red	5	Jane
4	Sam	Blue	x	x	x	x	x
5	Lisa	Green	x	x
6	Mary	Green			x	x
7	Jane	Green					x
8	Lisa	Yellow				x	x
9	Gary	Yellow	x	x	x
10
Log

Cell Formulas
Range	Formula
K2:K3	K2	=INDEX($A$2:$A$9,AGGREGATE(15,6,(ROW($A$2:$A$9)-ROW($A$2)+1)/($B$2:$B$9=I2)/(INDEX($C$2:$G$9,,J2)="x"),1))