生死由命富贵在天 发表于 2021-12-24 11:24:00

判断村委会还是居委会

奔跑吧梦想 发表于 2022-1-7 12:47:32

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

心如兰 发表于 2022-2-8 18:20:13


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

拙染 发表于 2022-2-13 10:47:46

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

单立人 发表于 2022-2-15 02:41:37

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

木头脑袋 发表于 2022-3-5 15:07:05

感谢帮忙，Z是什么意思

外星人罗纳尔多 发表于 2022-3-28 02:43:27

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"村","村委会"),"居","居委会"),"社","社区居委会")
页: [1]
查看完整版本: 判断村委会还是居委会