灞卞鐤戜技鎺掗櫎
=IF(COUNT(SEARCH({"灞卞澶у彅","鎴戞槸灞卞","灞卞澹?,"灞卞路鍙插瘑鏂?,"灞卞路娌冨皵椤?,"灞卞路楹﹀厠甯冮浄灏?,"灞卞鍥?,"灞卞路娌冨皵椤?,"灞卞鐨勬晠浜?,"灞卞鑰佸彅","灞卞鎽勫奖妫?,"闄冲北濮?,"灞卞aero","灞卞楂樺痉","鎸囩幆鐜?,"鏉冨姏鐨勬父鎴?,"灞卞鍜屾礇","鍒嗚缁嗚優 灞卞","灞卞路鏂櫘鎷夌壒","鏂扮洏","缃笟","灞卞路闃挎柉鍔犻噷鏅?,"娲涘熀","灞卞鑾辩洘","灞卞娲涘厠缁村皵","灞卞路娲涢煢","濂界墖","鐢靛奖","鑻辫秴","鐞冮槦","瓒崇悆","銕?,"鍦颁骇","澶х墖","鍠滃墽","娓告垙","鏂鍏?},C2)),"NO",IF(COUNT(SEARCH({"灞卞澶у彅","鎴戞槸灞卞","灞卞澹?,"灞卞路鍙插瘑鏂?,"灞卞路娌冨皵椤?,"灞卞路楹﹀厠甯冮浄灏?,"灞卞鍥?,"灞卞路娌冨皵椤?,"灞卞鐨勬晠浜?,"灞卞鑰佸彅","灞卞鎽勫奖妫?,"闄冲北濮?,"灞卞aero","灞卞楂樺痉","鎸囩幆鐜?,"鏉冨姏鐨勬父鎴?,"灞卞鍜屾礇","鍒嗚缁嗚優 灞卞","灞卞路鏂櫘鎷夌壒","鏂扮洏","缃笟","灞卞路闃挎柉鍔犻噷鏅?,"娲涘熀","灞卞鑾辩洘","灞卞娲涘厠缁村皵","灞卞路娲涢煢","濂界墖","鐢靛奖","鑻辫秴","鐞冮槦","瓒崇悆","銕?,"鍦颁骇","澶х墖","鍠滃墽","娓告垙","鏂鍏?},D2)),"NO",IF(COUNT(SEARCH({"灞卞澶у彅","鎴戞槸灞卞","灞卞澹?,"灞卞路鍙插瘑鏂?,"灞卞路娌冨皵椤?,"灞卞路楹﹀厠甯冮浄灏?,"灞卞鍥?,"灞卞路娌冨皵椤?,"灞卞鐨勬晠浜?,"灞卞鑰佸彅","灞卞鎽勫奖妫?,"闄冲北濮?,"灞卞aero","灞卞楂樺痉","鎸囩幆鐜?,"鏉冨姏鐨勬父鎴?,"灞卞鍜屾礇","鍒嗚缁嗚優 灞卞","灞卞路鏂櫘鎷夌壒","鏂扮洏","缃笟","灞卞路闃挎柉鍔犻噷鏅?,"娲涘熀","灞卞鑾辩洘","灞卞娲涘厠缁村皵","灞卞路娲涢煢","濂界墖","鐢靛奖","鑻辫秴","鐞冮槦","瓒崇悆","銕?,"鍦颁骇","澶х墖","鍠滃墽","娓告垙","鏂鍏?},E2)),"NO","YES")))
灞卞鍏抽敭璇?
=IF(COUNT(SEARCH({"灞卞","Sam's Club","灞卞浼氬憳搴?,"灞卞浼氬憳鍟嗗簵","灞卞搴?,"灞卞app","鏋侀€熻揪","灞卞鍏ㄧ悆璐?,"Member's Mark","MM","鍟嗗簵","浼氬憳搴?,"瓒呭競","灞卞瓒呭競","楂樼浼氬憳鍒跺晢搴?,"鍗撹秺浼氬憳","浼氬憳鍒跺害","鍏ㄥ浗璋冧环","鍏嶈垂璇曞悆","鐧句竾婢崇墰","婢虫床鐗涜倝","婢虫床鐗涙帓","鐗涜倝","婢虫床璋烽ゲ鐗涜倝","娓呰繙缇庡楦?,"levis","鏉庣淮鏂?,"鎴存．/Dyson","渚濅簯","绾㈤厭","璐濆痉鐜?,"閮戒箰瓒呯敎钑?,"鑿插緥瀹捐秴鐢滆晧","棣欒晧","the north face","椋炲ぉ鑼呭彴","鑼呭彴","鐑ら浮","MM鍧氭灉","MM鏉鹃湶鐘跺阀鍏嬪姏","MM鍏ㄨ剛鐗涘ザ","寰峰浗杩涘彛鐗涘ザ","鐗涘ザ","MM鏃ユ湰鑽夎帗","MM鑽夎帗","鏃ユ湰杩涘彛鑽夎帗","MM杞﹀帢瀛?,"MM鏅哄埄j绾ц溅鍘樺瓙","JJ绾ф櫤鍒╄溅鍘樺瓙","姒磋幉鍗冨眰铔嬬硶","鍗楃編鐧藉铏?,"鏂扮涓芥梾琛岀"},C2)),"YES",IF(COUNT(SEARCH({"灞卞","Sam's Club","灞卞浼氬憳搴?,"灞卞浼氬憳鍟嗗簵","灞卞搴?,"灞卞app","鏋侀€熻揪","灞卞鍏ㄧ悆璐?,"Member's Mark","MM","鍟嗗簵","浼氬憳搴?,"瓒呭競","灞卞瓒呭競","楂樼浼氬憳鍒跺晢搴?,"鍗撹秺浼氬憳","浼氬憳鍒跺害","鍏ㄥ浗璋冧环","鍏嶈垂璇曞悆","鐧句竾婢崇墰","婢虫床鐗涜倝","婢虫床鐗涙帓","鐗涜倝","婢虫床璋烽ゲ鐗涜倝","娓呰繙缇庡楦?,"levis","鏉庣淮鏂?,"鎴存．/Dyson","渚濅簯","绾㈤厭","璐濆痉鐜?,"閮戒箰瓒呯敎钑?,"鑿插緥瀹捐秴鐢滆晧","棣欒晧","the north face","椋炲ぉ鑼呭彴","鑼呭彴","鐑ら浮","MM鍧氭灉","MM鏉鹃湶鐘跺阀鍏嬪姏","MM鍏ㄨ剛鐗涘ザ","寰峰浗杩涘彛鐗涘ザ","鐗涘ザ","MM鏃ユ湰鑽夎帗","MM鑽夎帗","鏃ユ湰杩涘彛鑽夎帗","MM杞﹀帢瀛?,"MM鏅哄埄j绾ц溅鍘樺瓙","JJ绾ф櫤鍒╄溅鍘樺瓙","姒磋幉鍗冨眰铔嬬硶","鍗楃編鐧藉铏?,"鏂扮涓芥梾琛岀"},D2)),"YES",IF(COUNT(SEARCH({"灞卞","Sam's Club","灞卞浼氬憳搴?,"灞卞浼氬憳鍟嗗簵","灞卞搴?,"灞卞app","鏋侀€熻揪","灞卞鍏ㄧ悆璐?,"Member's Mark","MM","鍟嗗簵","浼氬憳搴?,"瓒呭競","灞卞瓒呭競","楂樼浼氬憳鍒跺晢搴?,"鍗撹秺浼氬憳","浼氬憳鍒跺害","鍏ㄥ浗璋冧环","鍏嶈垂璇曞悆","鐧句竾婢崇墰","婢虫床鐗涜倝","婢虫床鐗涙帓","鐗涜倝","婢虫床璋烽ゲ鐗涜倝","娓呰繙缇庡楦?,"levis","鏉庣淮鏂?,"鎴存．/Dyson","渚濅簯","绾㈤厭","璐濆痉鐜?,"閮戒箰瓒呯敎钑?,"鑿插緥瀹捐秴鐢滆晧","棣欒晧","the north face","椋炲ぉ鑼呭彴","鑼呭彴","鐑ら浮","MM鍧氭灉","MM鏉鹃湶鐘跺阀鍏嬪姏","MM鍏ㄨ剛鐗涘ザ","寰峰浗杩涘彛鐗涘ザ","鐗涘ザ","MM鏃ユ湰鑽夎帗","MM鑽夎帗","鏃ユ湰杩涘彛鑽夎帗","MM杞﹀帢瀛?,"MM鏅哄埄j绾ц溅鍘樺瓙","JJ绾ф櫤鍒╄溅鍘樺瓙","姒磋幉鍗冨眰铔嬬硶","鍗楃編鐧藉铏?,"鏂扮涓芥梾琛岀"},E2)),"YES","NO")))
|
[复制链接]
发表于 2020-12-13 10:57
