本溪：
=IF(COUNTIF(A1,"*平山*")=1,"平山区",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,"朝阳市",IF(COUNTIF(A1,"*双塔*")=1,"双塔区",IF(COUNTIF(A1,"*龙城*")=1,"龙城区",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,"银州区",IF(COUNTIF(A1,"*清河*")=1,"清河区",IF(COUNTIF(A1,"*新区*")=1,"铁岭新城区",IF(COUNTIF(A1,"*调兵*")=1,"调兵山市",IF(COUNTIF(A1,"*开原*")=1,"开原市",IF(COUNTIF(A1,"*铁县*")=1,"铁岭县",IF(COUNTIF(A1,"*西丰*")=1,"西丰县",IF(COUNTIF(A1,"*昌图*")=1,"昌图县",IF(COUNTIF(A1,"*铁岭经济技术开发区*")=1,"铁岭经济技术开发区",IF(COUNTIF(A1,"*铁岭高新产业开发区*")=1,"铁岭高新产业开发区",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)))))