Find closest value in a multi-row/column table

[dtdyson]

Hi All,
If I have the table below (just an APR table showing number of monthly payments and APR values and what the finance charge per $100 original loan would be) and I know the number of payments as well as the finance charge, how do I find the APR via Excel formula? I want to be able to enter different numbers in B12 and B13 (so, perhaps I know it's 24 payments and the charge is $4.77 - I want the result to show cell C6).

Thank you!!

 

[Fluff]

Hi & welcome to MrExcel.
How about one of these three options

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2		4	4.5	5	5.5	6	6.5	7	7.5	8	8.5	9	9.5	10
3	6	1.1	1.3	1.5	1.7	1.9	2.1	2.3	2.5	2.7	2.9	3.1	3.3	3.5
4	12	3.7	3.9	4.1	4.3	4.5	4.7	4.9	5.1	5.3	5.5	5.7	5.9	6.1
5	18	6.3	6.5	6.7	6.9	7.1	7.3	7.5	7.7	7.9	8.1	8.3	8.5	8.7
6	24	8.9	9.1	9.3	9.5	9.7	9.9	10.1	10.3	10.5	10.7	10.9	11.1	11.3
7	30	11.5	11.7	11.9	12.1	12.3	12.5	12.7	12.9	13.1	13.3	13.5	13.7	13.9
8	36	14.1	14.3	14.5	14.7	14.9	15.1	15.3	15.5	15.7	15.9	16.1	16.3	16.5
9	48	16.7	16.9	17.1	17.3	17.5	17.7	17.9	18.1	18.3	18.5	18.7	18.9	19.1
10	60	19.3	19.5	19.7	19.9	20.1	20.3	20.5	20.7	20.9	21.1	21.3	21.5	21.7
11			Nearest values to B12
12		12.43	Lower	Greater	Closest
13		30	6	6.5	6.5
Data

Cell Formulas
Range	Formula
C13	C13	=XLOOKUP(B12,XLOOKUP(B13,A3:A10,B3:N10,"",0),B2:N2,"",-1)
D13	D13	=XLOOKUP(B12,XLOOKUP(B13,A3:A10,B3:N10,"",0),B2:N2,"",1)
E13	E13	=XLOOKUP(MIN(ABS(XLOOKUP(B13,A3:A10,B3:N10,"",0)-B12)),ABS(XLOOKUP(B13,A3:A10,B3:N10,"",0)-B12),B2:N2,"",0)