Match and Index...

[mad3]

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...

	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>

​

 

[mad3]

comment about result in cell A5 is supposed to be D1.

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C	D
1	11		23	-3
2	12
3	13		16
4	14
5	15
6	16
7	21
8	22
9	23
10	24
11	25
12	26
13	31
14	32
Sheet