判斷是否全在范围内 (10481)

D3{=IF(COUNT(MATCH(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,"，",","),"-",","),",",REPT(" ",99)),ROW($1:$5)*99-98,99)),ROW(INDIRECT(SUBSTITUTE(VLOOKUP(A3,G:H,2,),"-",":")))&"",))=SUM(N(ISERR(-(0&MID(B3,ROW($1:$99),1)))))+1,"在范围内","不在范围内")