B1公式：
=IF(COUNT(FIND({"电感","0201"},A1))=2,"L0603","")
或者用这公式：
=IF(AND(COUNTIF(A1,{"*电感*";"*0201*"})),"L0603","")
