indirect函数的用法

shufeabb

indirect.rar (10.17 KB, 下载次数: 150)

2019-2-12 13:08 上传

点击文件名下载附件

thanks very much.

玄素

1. =SUMIF(INDIRECT($A3&"!a:a"),$B3,INDIRECT($A3&"!"&C$1&1))

复制代码

不借助标黄的B\C:

1. =SUMIF(INDIRECT($A3&"!a:a"),$B3,INDIRECT($A3&"!"&CHAR(64+COLUMN(B1))&1))

复制代码

fenglingbear

帮顶，我感觉可以用iferror+index+match来用。

mmlzh

=INDIRECT("'"&A3&"'!B"&E3)
=INDIRECT("'"&A3&"'!C"&E3)

或
=SUMIF(INDIRECT("'"&A3&"'!A:A"),B3,INDIRECT("'"&A3&"'!B:B"))
=SUMIF(INDIRECT("'"&A3&"'!A:A"),B3,INDIRECT("'"&A3&"'!C:C"))

新手路上

Enter the following formula in C3 cell and drop it down.

1. =INDIRECT($A3&"!"&CHAR(65+COLUMN(A1))&$E3)

复制代码

满坛皆为吾师

C3右拉下拉

1. =INDIRECT($A3&"!"&C$1&$E3)

复制代码

sayhi95

新手路上 发表于 2019-2-12 13:24
Enter the following formula in C3 cell and drop it down.

这个花要送的，可惜今天花花的限额用完了，厉害的，见招拆招，来是卡姆去是狗，哈哈~

sayhi95

我晕，刚才我说了句啥啊，怎么就要审核了呢.....

leon3131

每天学习一下！

zxx212

1. =OFFSET(INDIRECT($A3&"!A1"),MATCH($B3,INDIRECT($A3&"!A:A"),)-1,COLUMN(A1))

复制代码

不借助黄标