A | B | C | D | F | G | H | |
1 | X | X | X | ||||
2 | ALPHA | BRAVO | CHARLIE | DELTA | ECHO | ||
3 | 4.23 | 4.20 | 5.45 | 6.00 | 4.23 | 4.23 | ECHO |
4 | 4.88 | 4.92 | 4.92 | 0.00 | 4.99 | 4.92 | CHARLIE |
5 | 5.58 | 4.88 | 6.23 | 6.23 | 5.58 | 5.58 | ECHO |
6 | 4.72 | 4.72 | 4.72 | 4.40 | 4.88 | 4.72 | CHARLIE |
<tbody>
</tbody>
The problem I have is populating H3. H3 needs to find the value from G3 in A3:F3 and return the value from row 2 from the column it was found in, keeping in mind that some of the columns were excluded from the original search that populated column G.
Many thanks for any help that can be given.