厚度范围分类 (9435)

C2=LOOKUP(LOOKUP(1,0/FIND(ROW($1:$99)&"cm",A2),ROW($1:$99)),{0,4,10,16},{4,1,2,3})

D2=LOOKUP(LOOKUP(1,0/FIND(ROW($1:$99)&"cm",A2),ROW($1:$99)),LEFT(F$2:F$5,FIND("cm",F$2:F$5)-1)*1,G$2:G$5)