ごめんなさい。INDEX( ,)を忘れていました。
A B
1 記号無し 0
2 LorN 3.4
3 VorT 5.1
4 PorI 7.5
5 PsorIs 8.5
6 2 10
7 3 15
8 4 20
9 5 25
10 32 30
11 42 35
12
13 4 16.8
A13
=INDEX(A$1:A$11,MATCH(TRUE,INDEX(B13<=B$1:B$11,),0))
A B
1 記号無し 0.0<=
2 LorN 0<3.4<=
3 VorT 3.4<5.1<=
4 PorI 5.1<7.5<=
5 PsorIs 7.5<8.5<=
6 2 8.5<10.0<=
7 3 10.0<15.0<=
8 4 15.0<20.0<=
9 5 20.0<25.0<=
10 32 25.0<30.0<=
11 42 30.0<35.0<=
12
13 4 16.8
A13
=INDEX(A$1:A$11,MATCH(TRUE,INDEX(B13-TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(B$1:B$11,"<=",),"<",REPT(" ",10)),10))<=0,),0))