數值區間表列 取對應值 多種方式 (13864)

H2=LOOKUP(1,0/(G2-LEFT(A$2:A$16,FIND("-",A$2:A$16)-1)>=0),B$2:B$16)

另解=LOOKUP(G2,TEXT(,"[$"&A$2:A$16&"]")/1,B$2:B$16)

另解=LOOKUP(G2,IMREAL(A$2:A$16&"i"),B$2:B$16)

另解=LOOKUP(G2,TEXT(1%,SUBSTITUTE(A$2:A$16,"-",";"))/1,B$2:B$16)