I have a number in cell C1 (23) and another number in cell D1 (-3). I want to lookup a value in a list and get the corresponding result X number of rows up or down based on the number in cell A5 (-3). In the example below, my end result should be 16; from column A6... Thanks for help from Mike in Cali...
<tbody>
</tbody>
A | |
1 | 11 |
2 | 12 |
3 | 13 |
4 | 14 |
5 | 15 |
6 | 16 |
7 | 21 |
8 | 22 |
9 | 23 |
10 | 24 |
11 | 25 |
12 | 26 |
13 | 31 |
14 | 32 |
<tbody>
</tbody>