提取的不准确，原因？

grldrkjhuy

选择A1，从所有的表中提取数据到新表sheet1中，公式套用后数据不准确？请大侠修改重新上传了文件

grldrkjhuy

=INDIRECT(INDEX({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"},--LEFT(TEXT(SMALL(IF(T(OFFSET(INDIRECT({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"}&"!C$1"),ROW($1:$60),))=$A$1,COLUMN($A:$T)/1%%+ROW($2:$60),10^10),ROW(A1)),"000000"),2))&"!r"&RIGHT(SMALL(IF(T(OFFSET(INDIRECT({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"}&"!C$1"),ROW($1:$60),))=$A$1,COLUMN($A:$T)/1%%+ROW($2:$60),10^10),ROW(A1)),4)&"C"&COLUMN(A1),)


谢谢大家，已经解决

cinlo

为啥不把学校列表放到一行或者一列呢？