二項區間取值 (14163)

 D10=INDEX(C$3:E$5,LOOKUP(1,0/(LEFT(B$3:B$5,3)-B10<=0),{1,2,3}),LOOKUP(1,0/(C$1:E$1=A10),{1,2,3}))

另解{=VLOOKUP(MATCH(B10,--TEXT(,"[$"&B$3:B$5&"]")),A:E,MATCH(A10,$1:$1,),)

另解=LOOKUP(B10,--LEFT(B$3:B$5,3),INDEX(C$3:E$5,,MATCH(A10,C$1:E$1,)))

另解=LOOKUP(B10,--LEFT(B$3:B$5,3),OFFSET(B$3:B$5,,MATCH(A10,$1:$1,)-2))