本帖最后由 神隐汀渚 于 2015-9-24 17:39 编辑
c5 =SUM(VLOOKUP($B5&"*",INDIRECT("'[对账日报表.xls]"&DAY(A5)&"'!$G$6:$AK$18"),N(IF({1},ROW($6:$7))),FALSE))
d5 =SUM(VLOOKUP($B5&"*",INDIRECT("'[对账日报表.xls]"&DAY(A5)&"'!$G$6:$AK$18"),N(IF({1},ROW($8:$12))),FALSE))
e5 =SUM(VLOOKUP($B5&"*",INDIRECT("'[对账日报表.xls]"&DAY(A5)&"'!$G$6:$AK$18"),13,FALSE))
f5 =SUM(VLOOKUP($B5&"*",INDIRECT("'[对账日报表.xls]"&DAY(A5)&"'!$G$6:$AK$18"),N(IF({1},ROW($14:$20))),FALSE))多谢楼主 让我懂了如何vlookup 实现多行多列引用