大神,帮忙改个公式

国棋

在汇总表里查找6个工作表对应的高和宽,详见附件
求助.zip (35.12 KB, 下载次数: 13)

2021-10-19 09:39 上传

点击文件名下载附件
求助.zip

吉人天佑

C2=VLOOKUP($B2,INDIRECT("'"&LOOKUP(1,0/COUNTIF(INDIRECT("'"&{"1#楼","2#楼","3#楼","4#楼","配建","门岗"}&"'!a:a"),$B2),{"1#楼","2#楼","3#楼","4#楼","配建","门岗"})&"'!a:z"),2+(C$1="高度"),0)

右拉下拉。

敢动中国

=LOOKUP(9^9,1/SUMIF(INDIRECT("'"&{"配建","门岗","4#楼","3#楼","1#楼"}&"'!a:a"),$B2,INDIRECT("'"&{"配建","门岗","4#楼","3#楼","1#楼"}&MID("'!b:b'!c:c",COLUMN(A1)*5-4,5)))^-1)

右拉下拉

这颗心稀巴烂

=VLOOKUP($B2,INDIRECT(INDEX("'"&{"1#楼";"3#楼";"4#楼";"门岗";"配建"}&"'!A:E",MATCH(,0/COUNTIF(INDIRECT("'"&{"1#楼";"3#楼";"4#楼";"门岗";"配建"}&"'!A:E"),$B2),))),COLUMN(B1),)