Help with function for a value within a matrix

[dhaynes]

I need help identifying the right function(s) to return a single value within a matrix with ranges...For example, using the matrix below and assuming a loan with an LTV of 67% and DSCR of 1.27, I would want to return the corresponding value of 93%. I feel like I could you use a series of IF (and) functions but I am also thinking that there is likely a more efficient way to do this. Any suggestions are welcome! Thank you!

 

[Cubist]

Try:

Book2
	A	B	C	D
1		0-35	36-45	46-55
2	0-1	85%	51%	51%
3	1.01-1.25	28%	2%	97%
4	1.26-1.30	0%	41%	21%
5
6
7	LTV	45%
8	DSCR	1.26
9	Result	41%
Sheet3

Cell Formulas
Range	Formula
B9	B9	=INDEX(B2:D4,XMATCH(B8,--TEXTBEFORE(A2:A4,"-"),-1),XMATCH(B7*100,--TEXTBEFORE(B1:D1,"-"),-1))

 

[dhaynes]

Perfect! Thank you!!

 

[Cubist]

You're welcome.