Formulas for 9 box grid

[bematthe]

I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I run into the same issue every time. The correct names for the other 8 boxes generate just fine, but the High-Low box either displays nothing, or pulls an incorrect name.
Any suggestions as to what might be causing this?

	B	C	D	E	F	G	H	I	J	K	L
1	Talent Review								Performance
2	Department/Group:							Potential	Low	Medium	High
3	Leader:								HighLow	HighMedium	HighHigh
4								High	0	Shadow Scruffy	Winston Charles
5	Employee Name	D Number	Current Employee Role	Current Manager	Potential	Performance				Tucker Marshall
6	Ginger Pye				High	Low
7	Shadow Scruffy				High	Medium
8	Winston Charles				High	High
9	Laila Serena				Medium	Low
10	Harper Shadow				Medium	Medium
11	Isobel Eli				Medium	High
12	Abigail Maragret				Well Positioned	Low
13	Tilly Ina				Well Positioned	Medium		(Hide)	MediumLow	MediumMedium	MediumHigh
14	Hunter Murphy				Well Positioned	High		Medium	Laila Serena	Harper Shadow	Isobel Eli
15	Tucker Marshall				High	Medium
16
17
18
19
20
21
22
23
24
25
26								(Hide)	Well PositionedLow	Well PositionedMedium	Well PositionedHigh
27								Well Positioned	Abigail Maragret	Tilly Ina	Hunter Murphy
28
29
30

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

9 box​

Worksheet Formulas Cell Formula J4 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(1:1)),2)) J5 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(2:2)),2)) J6 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(3:3)),2)) J7 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(4:4)),2)) J8 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(5:5)),2)) J9 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(6:6)),2)) J10 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(7:7)),2)) J11 =IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(8:8)),2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula K4 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(1:1)),2))} L4 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(1:1)),2))} K5 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(2:2)),2))} L5 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(2:2)),2))} K6 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(3:3)),2))} L6 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(3:3)),2))} K7 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(4:4)),2))} L7 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(4:4)),2))} K8 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(5:5)),2))} L8 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(5:5)),2))} K9 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(6:6)),2))} L9 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(6:6)),2))} K10 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(7:7)),2))} L10 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(7:7)),2))} K11 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(8:8)),2))} L11 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(8:8)),2))} J12 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(9:9)),2))} K12 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(9:9)),2))} L12 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(9:9)),2))} J14 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(1:1)),2))} K14 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(1:1)),2))} L14 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(1:1)),2))} J15 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(2:2)),2))} K15 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(2:2)),2))} L15 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(2:2)),2))} J16 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(3:3)),2))} K16 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(3:3)),2))} L16 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(3:3)),2))} J17 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(4:4)),2))} K17 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(4:4)),2))} L17 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(4:4)),2))} J18 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(5:5)),2))} K18 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(5:5)),2))} L18 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(5:5)),2))} J19 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(6:6)),2))} K19 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(6:6)),2))} L19 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(6:6)),2))} J20 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(7:7)),2))} K20 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(7:7)),2))} L20 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(7:7)),2))} J21 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(8:8)),2))} K21 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(8:8)),2))} L21 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(8:8)),2))} J22 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(9:9)),2))} K22 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(9:9)),2))} L22 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(9:9)),2))} J23 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(10:10)),2))} K23 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(10:10)),2))} L23 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(10:10)),2))} J24 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(11:11)),2))} K24 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(11:11)),2))} L24 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(11:11)),2))} J25 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(12:12)),2))} K25 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(12:12)),2))} L25 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(12:12)),2))} J27 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(1:1)),2))} K27 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(1:1)),2))} L27 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(1:1)),2))} J28 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(2:2)),2))} K28 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(2:2)),2))} L28 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(2:2)),2))} J29 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(3:3)),2))} K29 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(3:3)),2))} L29 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(3:3)),2))} J30 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(4:4)),2))} K30 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(4:4)),2))} L30 {=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(4:4)),2))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

<tbody>
</tbody>

 

[sandy666]

something like that?

Potential	Low	Medium	High
High	Ginger Pye		Winston Charles
Medium	Laila Serena	Harper Shadow	Isobel Eli
Well Positioned	Abigail Maragret	Tilly Ina	Hunter Murphy

Edit:
Wrong, I missed error in blank cell

 

[sandy666]

here is:

Potential	Low	Medium	High
High	Ginger Pye	Shadow Scruffy,Tucker Marshall	Winston Charles
Medium	Laila Serena	Harper Shadow	Isobel Eli
Well Positioned	Abigail Maragret	Tilly Ina	Hunter Murphy

 

[bematthe]

So my question would be, how did you adjust the formula so that the name(s) going in the "HighLow" box populated?

 

[bematthe]

ADVERTISEMENT

I don't think I included the hidden columnA in the original post, if that helps.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Talent Review</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #BDD7EE;;">Performance</td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Department/Group:</td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #BDD7EE;;">Potential</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Low</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Medium</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">High</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Leader:</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;">0</td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Shadow Scruffy</td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Winston Charles</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="border-right: 1px solid black;;">Rating</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Employee Name</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">D Number</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">Current Employee Role</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">Current Manager</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #4472C4;;">Potential</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #4472C4;;">Performance</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Tucker Marshall</td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="border-right: 1px solid black;;">HighLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Ginger Pye</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="border-right: 1px solid black;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Shadow Scruffy</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="border-right: 1px solid black;;">HighHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Winston Charles</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="border-right: 1px solid black;;">MediumLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Laila Serena</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="border-right: 1px solid black;;">MediumMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Harper Shadow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="border-right: 1px solid black;;">MediumHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Isobel Eli</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="border-right: 1px solid black;;">Well PositionedLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Abigail Maragret</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="border-right: 1px solid black;;">Well PositionedMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Tilly Ina</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">(Hide)</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumLow</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="border-right: 1px solid black;;">Well PositionedHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Hunter Murphy</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Laila Serena</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Harper Shadow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Isobel Eli</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="border-right: 1px solid black;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Tucker Marshall</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">(Hide)</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedLow</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Abigail Maragret</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Tilly Ina</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Hunter Murphy</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr></tbody></table><p style="width:4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">9 box</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J4</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J5</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J6</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J7</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J8</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J9</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J10</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J11</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A7</th><td style="text-align:left">=F7&G7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A8</th><td style="text-align:left">=F8&G8</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A9</th><td style="text-align:left">=F9&G9</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A10</th><td style="text-align:left">=F10&G10</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A11</th><td style="text-align:left">=F11&G11</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A12</th><td style="text-align:left">=F12&G12</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A13</th><td style="text-align:left">=F13&G13</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A14</th><td style="text-align:left">=F14&G14</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A15</th><td style="text-align:left">=F15&G15</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A20</th><td style="text-align:left">=F20&G20</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A21</th><td style="text-align:left">=F21&G21</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A22</th><td style="text-align:left">=F22&G22</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A23</th><td style="text-align:left">=F23&G23</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A24</th><td style="text-align:left">=F24&G24</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A25</th><td style="text-align:left">=F25&G25</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A26</th><td style="text-align:left">=F26&G26</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A27</th><td style="text-align:left">=F27&G27</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A28</th><td style="text-align:left">=F28&G28</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A29</th><td style="text-align:left">=F29&G29</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A30</th><td style="text-align:left">=F30&G30</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K4</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L4</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K5</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L5</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K6</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L6</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K7</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L7</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K8</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L8</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K9</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L9</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K10</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L10</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K11</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L11</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

 

[sandy666]

if this is what you want, here is M-code for PowerQuery (based on 1st post):

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Employee Name", type text}, {"ID Number", type any}, {"Current Employee Role", type any}, {"Current Manager", type any}, {"Potential", type text}, {"Performance", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"ID Number", "Current Employee Role", "Current Manager"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Potential", "Performance"}, {{"Count", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.Column([Count],"Employee Name")),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Removed Columns1" = Table.RemoveColumns(#"Extracted Values",{"Count"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns1", List.Distinct(#"Removed Columns1"[Performance]), "Performance", "Custom")
in
    #"Pivoted Column"[/SIZE]

 

[Fluff]

ADVERTISEMENT

Your formula in J4 down should be an array formula like the others.

 

[bematthe]

Your formula in J4 down should be an array formula like the others.

Aha! Thank you! I knew it has to be something silly that I was just missing. Why I kept missing it, I have no idea.
Thank you!

 

[Fluff]

You're welcome