本溪：
=IF(COUNTIF(A1,"*平山*")=1,"平山區(qū)",IF(COUNTIF(A1,"*明山*")=1,"明山區(qū)",IF(COUNTIF(A1,"*溪湖*")=1,"溪湖區(qū)",IF(COUNTIF(A1,"*南芬*")=1,"南芬區(qū)",IF(COUNTIF(A1,"*本溪滿族*")=1,"本溪滿族自治縣",IF(COUNTIF(A1,"*桓仁滿族 *")=1,"桓仁滿族自治縣 ",0))))))

朝陽：
=IF(COUNTIF(A1,"*朝陽市*")=1,"朝陽市",IF(COUNTIF(A1,"*雙塔*")=1,"雙塔區(qū)",IF(COUNTIF(A1,"*龍城*")=1,"龍城區(qū)",IF(COUNTIF(A1,"*北票*")=1,"北票市",IF(COUNTIF(A1,"*凌源*")=1,"凌源市",IF(COUNTIF(A1,"*朝陽縣*")=1,"朝陽縣",IF(COUNTIF(A1,"*建平*")=1,"建平縣",IF(COUNTIF(A1,"*喀左*")=1,"喀喇沁左翼蒙古族自治縣",0))))))))

鐵嶺：
=IF(COUNTIF(A1,"*銀州*")=1,"銀州區(qū)",IF(COUNTIF(A1,"*清河*")=1,"清河區(qū)",IF(COUNTIF(A1,"*新區(qū)*")=1,"鐵嶺新城區(qū)",IF(COUNTIF(A1,"*調(diào)兵*")=1,"調(diào)兵山市",IF(COUNTIF(A1,"*開原*")=1,"開原市",IF(COUNTIF(A1,"*鐵縣*")=1,"鐵嶺縣",IF(COUNTIF(A1,"*西豐*")=1,"西豐縣",IF(COUNTIF(A1,"*昌圖*")=1,"昌圖縣",IF(COUNTIF(A1,"*鐵嶺經(jīng)濟技術開發(fā)區(qū)*")=1,"鐵嶺經(jīng)濟技術開發(fā)區(qū)",IF(COUNTIF(A1,"*鐵嶺高新產(chǎn)業(yè)開發(fā)區(qū)*")=1,"鐵嶺高新產(chǎn)業(yè)開發(fā)區(qū)",0))))))))))

站型選擇

=IF(COUNTIF(B2,"*LY*")=1,"室分",IF(COUNTIF(B2,"*LW*")=1,"室分",IF(COUNTIF(B2,"*LH*")=1,"宏站",IF(COUNTIF(B2,"*LR*")=1,"宏站",IF(COUNTIF(B2,"*LP*")=1,"室分",0)))))