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


[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]11[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]13[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]14[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]15[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]21[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]22[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]24[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]26[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]31[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]32[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

​

 

[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