B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
1 | PROJECT | 2019Q1 | 2019Q2 | 2019Q3 | 2019Q4 | 2019Q1 | 2019Q2 | 2019Q3 | 2019Q4 | 2019Q1 | 2019Q2 | 2019Q3 | 2019Q4 | OP | ||
2 | YU | 4 | 5 | 6 | 45 | 77 | 7 | 7 | 5 | 98 | 8 | 6 | 99 | |||
3 | HU | 12 | 34 | 6 | 7 | 8 | 1 | 3 | 4 | 6 | 7 | 9 | 2 | 2019Q3 | ||
4 | PO | 15 | 65 | 45 | 18 | 25 | 45 | 66 | 5 | 8 | 8 | 6 | 9 | |||
5 | OP | 78 | 9 | 51 | 5 | 7 | 56 | 90 | 89 | 8 | 64 | 431 | 2019Q2 |
<tbody>
</tbody>
Hi,
From the above data I'm hoping to achieve the below:
Formula 1:
- Looks along C1:F1 and matches the data in cell Q3
- Looks down B2:B5 and matches the data in cell Q1
- Answer = 51 (cell e5)
Formula2:
- Looks along K1:N1 and matches the data in cell Q5
- Looks down B2:B5 and matches the data in cell Q1
- Answer = 8 (cell L5)
with
I had posted something similar in recent days but confused it with an incorrect table. Ultimately, Formula2 is what I'm struggling with as the traditional Index-Match will not work because there are multiple 2019Q2 for example on row 1.
Any help is much appreciated.
Thanks
Ryan
Last edited: