求教高手,有什么函数可以替代下面的IF函数或只使用一次IF函数?=IF(B2=1,'sheet1'!B11:B5000,IF(B2=2,'sheet2'!B11:B5000,IF(B2=3,'sheet3'!B11:B5000,if(B2=4,'sheet4'!B11:B5000,IF(B2=5,'sheet5'!B11:B5000,IF(B2=6,'sheet6'!B11:B5000,IF(
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/24 10:59:09
求教高手,有什么函数可以替代下面的IF函数或只使用一次IF函数?=IF(B2=1,'sheet1'!B11:B5000,IF(B2=2,'sheet2'!B11:B5000,IF(B2=3,'sheet3'!B11:B5000,if(B2=4,'sheet4'!B11:B5000,IF(B2=5,'sheet5'!B11:B5000,IF(B2=6,'sheet6'!B11:B5000,IF(
求教高手,有什么函数可以替代下面的IF函数或只使用一次IF函数?
=IF(B2=1,'sheet1'!B11:B5000,IF(B2=2,'sheet2'!B11:B5000,IF(B2=3,'sheet3'!B11:B5000,if(B2=4,'sheet4'!B11:B5000,IF(B2=5,'sheet5'!B11:B5000,IF(B2=6,'sheet6'!B11:B5000,IF(B2=7,'sheet7'!B11:B5000,IF(B2=8,'sheet8'!B11:B5000,IF(B2=9,'sheet9'!B11:B5000,IF(B2=10,'sheet10'!B11:B5000,IF(B2=11,'sheet11'!B11:B5000,IF(B2=12,'sheet12'!B11:B5000,""))))))))))))
求教高手,有什么函数可以替代下面的IF函数或只使用一次IF函数?=IF(B2=1,'sheet1'!B11:B5000,IF(B2=2,'sheet2'!B11:B5000,IF(B2=3,'sheet3'!B11:B5000,if(B2=4,'sheet4'!B11:B5000,IF(B2=5,'sheet5'!B11:B5000,IF(B2=6,'sheet6'!B11:B5000,IF(
=INDIRECT("'sheet"&B2&"'!B11:B5000")