在以下列A名单里,我想在列B设置一个公式:如果单元格A1查找到名字里有Inc,则B1返回Inc,如果查找到Emp ON,则返回Emp ON,如果前面这两项都没有找到,则返回SP.
请大侠指教!谢谢!
Alawi {Inc}, Bassam | Abdalla {Inc}, Ayman | Alboino {Inc}, Mark | Alexander {Inc}, Bob | Alexander {Inc}, Dale 63 | Alexander {Inc}, Dale 50 | Ali {Inc}, Salman | Allain, Maurice | Anand {Inc}, Munish | Antle, Perry | Arnsby {Inc}, Walt | Asadnia {Emp ON}, Siavash | Atienza {Emp ON}, Priscilla | Bagheriasl {Inc}, Reza | Bagshaw {Inc}, Sean | Bailey {Inc}, Gerry | Barnes {Inc}, Chris | Barry {Emp AB}, Zachary D | Bath {Inc}, Honour | Beange, Steve | Beaton {Inc}, Dawne | Bell {Inc}, John | Bellamy, Paul | Besada {Inc}, Ayman | Besseling {Inc}, Jules | Bilal {Inc}, Mohammad | Binnendyk {Inc}, John | Blackwood {Inc}, Peter | Boghdady {Inc}, Mina | Bond {Inc}, John | Bond {Inc}, John | Boric {Inc}, Vladimir |
|