Hi
I'm really struggling with this. I have a table with my data:
I need to find the first value in the range B14:R35 that corresponds to the selected search value in Column A. So for example, if I select '2' from column A, the first value should be '1' from column I. However, I have tried varying combinations of INDEX and MATCH (also tried XLOOKUP, and that confused me even more, but cannot get it to work! Can anyone assist? I'm not a great user of Excel these days, so haven't a clue how to achieve this.
Thank you
Mark
I'm really struggling with this. I have a table with my data:
-3 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | ||||||||||||
-2 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | |||||||||||
-1 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | ||||||||||
0 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | |||||||||
1 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | ||||||||
2 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | |||||||
3 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
4 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
5 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
6 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
7 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
8 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
9 | 1.0 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||
10 | 1.4 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | |||||||
11 | 2.0 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||||
12 | 2.8 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | |||||||||
13 | 4.0 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | ||||||||||
14 | 5.6 | 8.0 | 11 | 16 | 22 | 32 | |||||||||||
15 | 8.0 | 11 | 16 | 22 | 32 | ||||||||||||
16 | 11 | 16 | 22 | 32 | |||||||||||||
17 | 16 | 22 | 32 | ||||||||||||||
18 | 22 | 32 | |||||||||||||||
I need to find the first value in the range B14:R35 that corresponds to the selected search value in Column A. So for example, if I select '2' from column A, the first value should be '1' from column I. However, I have tried varying combinations of INDEX and MATCH (also tried XLOOKUP, and that confused me even more, but cannot get it to work! Can anyone assist? I'm not a great user of Excel these days, so haven't a clue how to achieve this.
Thank you
Mark