字符少與多於數據 查詢 (12567)

F5:G5 下拉{=INDEX($B:$B,SMALL(IF(ISNUMBER(FIND(LEFT(F$4,MAX(MMULT(1-ISERR(FIND(LEFT(F$4,COLUMN($A:$I)),$A$2:$A$28)),ROW(1:9)^0))),$A$2:$A$28))*(COUNTIF(G$5:G$16,$B$2:$B$28)=0),ROW($2:$28),99),ROW(A1)))&""