Hi All
I cannot see how to work this out, but I suspect it is very straightforward. I have a table as shown.
<tbody>
</tbody>
On another WS -
In cell B2 I will type a number from the horizontal row between 1 and 7
In cell C2, I will type a number from the vertical column between 1 and 6
In cell D2, I want to automatically populate the letter from the grid above...
For example..........
<tbody>
</tbody>
etc.
Entry in Col C and D will be via drop down list. What is the formula to auto populate Col D?
Kindest regards, and very many thanks
Matt
I cannot see how to work this out, but I suspect it is very straightforward. I have a table as shown.
1 | 2 | 3 | 4 | 5 | 6 | 7 | |
1 | A | A | A | A | B | B | B |
2 | A | A | A | B | B | B | B |
3 | A | A | B | B | B | B | C |
4 | A | B | C | D | E | F | G |
5 | B | C | D | E | F | G | H |
6 | C | D | E | F | G | H | H |
<tbody>
</tbody>
On another WS -
In cell B2 I will type a number from the horizontal row between 1 and 7
In cell C2, I will type a number from the vertical column between 1 and 6
In cell D2, I want to automatically populate the letter from the grid above...
For example..........
Horizontal 1-7 | Vertical 1-6 | Grid |
4 | 4 | D |
6 | 1 | B |
<tbody>
</tbody>
etc.
Entry in Col C and D will be via drop down list. What is the formula to auto populate Col D?
Kindest regards, and very many thanks
Matt