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?
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
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
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>
<tbody>
</tbody>