判断村委会还是居委会

生死由命富贵在天

5454.rar (7.1 KB, 下载次数: 12)

2021-12-24 11:24 上传

点击文件名下载附件
5454.rar

奔跑吧梦想

=IFERROR(LOOKUP(1,0/(LEFT(A1,2)={"直属","集东","刘集","花井","刘湾"}),{"直属居委会","集东居委会","刘集社区居委会","花井社区居委会","刘湾社区居委会"}),LEFT(A1,2)&"村委会")

心如兰

=IFNA(LOOKUP(1,0/FIND({"直属","集东","刘集","花井","刘弯"},A1),{"直属","集东居委会","刘集社区居委会","花井社区居委会","刘弯社区居委会"}),A1&"委会")

拙染

=IFERROR(LOOKUP(1,0/FIND({"直属","集东","刘集","花井","刘湾"},A1),{"直属居委会","集东居委会","刘集社区居委会","花井社区居委会","刘湾社区居委会"}),LEFT(A1,2)&"村委会")看看对不对吧

单立人

=LEFT(A1,2)&CHOOSE(MATCH(1,MMULT(COUNTIF(A1,{"直属","集东","Z";"刘集","花井","刘湾";"Z","Z","*"}&"*"),{1;1;1}),),"居","社区居","村")&"委会"

木头脑袋

感谢帮忙，Z是什么意思

外星人罗纳尔多

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"村","村委会"),"居","居委会"),"社","社区居委会")