數字找區間值 (14159)

E2:F9{=INDEX(J:J,MATCH(1=1,LEFT($I$2:$I$8,FIND("~",$I$2:$I$8&"~")-1)-$D2<=0,)+1)

R2:S9=LOOKUP($Q2,$M:$M,N:N)