return value based on the number that matches any number in three columns

[MMM_84]

Hello! Could you help me to return the value based on the number that falls between numbers in three columns.
So, I need a function into column J (highlighted in yellow).
Column I has numbers that fall between the numbers in columns B,C and D. Depending where in a range the number, column J should bring a number from column E
Index match or xlookup?

Book1
	A	B	C	D	E	F	G	H	I	J
1
2		Min	Mid	Max	Level				Numbers	value to be returned
3		59	66	78	5				68	5
4		79	85	99	7				115	9
5		100	114	130	9				155
6		131	143	160	10				70
7
8
Sheet1

 

[hagia_sofia]

Hello, how about:

=LET(
a,B3:D6,
b,E3:E6,
c,TOCOL(a),
d,TOCOL(IF(SEQUENCE(,COLUMNS(a)),b)),
XLOOKUP(I3:I6,c,d,,-1))

 

[saboh12617]

Hello,
There are probably easier formulas with dynamic arrays, but a solution working on XL 2016 is

=INDEX($E$3:$E$6;MATCH(VLOOKUP(I3;$B$3:$B$6;1;TRUE);$B$3:$B$6;0))

Supposing your values are ordered from lower to higher when going down.

 

[MMM_84]

Hello,
There are probably easier formulas with dynamic arrays, but a solution working on XL 2016 is

=INDEX($E$3:$E$6;MATCH(VLOOKUP(I3;$B$3:$B$6;1;TRUE);$B$3:$B$6;0))

Supposing your values are ordered from lower to higher when going down.

Thanks!!! works perfect