ä¸å¥½ææ,å æ°æ®å¤ªå¤,æå¾è¾æ°æ®äº,åªè¾äº3è¡æ°æ®æ¥éªè¯å ¬å¼,ä¸å¾
D27å
¬å¼:
=IFERROR(LOOKUP(C27,IFERROR(--SUBSTITUTE(REPLACE(OFFSET($A$3,MATCH(1,0/(B27>=--LEFT($A$4:$A$24,3))),LOOKUP(A27,{20,30,40,50},{1,6,11,16}),,5),FIND("-",OFFSET($A$3,MATCH(1,0/(B27>=--LEFT($A$4:$A$24,3))),LOOKUP(A27,{20,30,40,50},{1,6,11,16}),,5)&"-"),9,),">",),),{1,3,5,3,1}),"")
æ°ç»å ¬å¼,æCTRL+SHIFT+å车ç»æ,ä¸æå¡«å