EXCEL匹配数据数据.md 141 B

=IF(OR(A1="", ISERROR(FILTER(B2:B6, ISNUMBER(SEARCH(TEXT(A1,"0"), A2:A6, 1))))), "", FILTER(B2:B6, ISNUMBER(SEARCH(TEXT(A1,"0"), A2:A6, 1))))