Hello everyone,
I have a table similar to this one.
|
100% |
90% |
80% |
Year 1 |
2% |
5% |
9% |
Year 2 |
4% |
14% |
20% |
Year 3 |
10% |
22% |
35% |
Year 4 |
25% |
30% |
50% |
I would like to get the corresponding percentage based on the headers of rows and columns.
For example, if it is Year 1 and 90%, I should get 5%.
Year 1 |
90% |
5% |
Year 4 |
100% |
25% |
Year 3 |
80% |
35% |
Thank you for your help in advance.