第1个回答 2019-03-14
把sheet2的名称改为"北京",sheet3改为"天津"
用简单点的办法,sheet2中的“合计:”与下面公式中的要一致
在sheet1中B2=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),2,)
C2=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),3,)
B3=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),4,)
c3=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),5,)
B4=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),6,)
c4=VLOOKUP("合计:",INDIRECT($A$1&"!a1:G7"),7,)
希望能用的上本回答被网友采纳