如何用公式显示若干个单元格都含有的文本.xls

王陈蔡李林李王_1=MID(Sheet1!$A$1,ROW(INDIRECT(1:&LEN(Sheet1!$A$1),1)王张蔡李杨李_2=MID(Sheet1!$A$2,ROW(INDIRECT(1:&LEN(Sheet1!$A$2),1)张蔡李陈王_3=MID(Sheet1!$A$3,ROW(INDIRECT(1:&LEN(Sheet1!$A$3),1)_1_2_3王王张陈张蔡蔡蔡李李李陈林杨王MATCH(_1,_2)MATCH(_1,_3)*ISNUMBER()=LOOKUP(TRUE,ISNUMBER(),_1)4520TRUE林4#N/A#N/AFALSE4#N/A#N/AFALSE4312TRUE4416TRUE=MID(Sheet1!$A$1,ROW(INDIRECT(1:&LEN(Sheet1!$A$1),1)=MID(Sheet1!$A$2,ROW(INDIRECT(1:&LEN(Sheet1!$A$2),1)=MID(Sheet1!$A$3,ROW(INDIRECT(1:&LEN(Sheet1!$A$3),1)=LOOKUP(TRUE,ISNUMBER(),_1)