使用间接功能 [英] Using Indirect Function

问题描述

你好



我有工作簿

仓库PMS第36周

仓库PMS第37周

仓库PMS第38周

然后我有一张带有这样的桌子的床单

 ABCDE 
周计划实际原因行动评论
 35 #REF！ ＃REF！ 
 36 #REF！ ＃REF！ 
 37 #REF！ ＃REF！ 
 38 #REF！ ＃REF！ 
 39 #REF！ ＃REF！ 

B列竞争中的每个REF

 ='[仓库PMS周37.xls]总PMS'！ $ E $ 113 

和Colum C

 ='[仓库PMS周38.xls]总PMS'！$ F $ 113 

现在我想做类似的事情我想在

仓库PMS周35.xls 随着INDIRECT（A2）继续，但我没有运气，我的公式不工作:( 
 
 
 
重点是我有喜欢52周，我希望将它们链接到这个表并从周期中获取值，这意味着当我改变A2：A6与其他nr如42或52时，表格将链接到这个工作簿
 
 
 
任何帮助？或任何更好的解决方案
解决方案
 
 E 
 
 < blockquote> 113 

和Colum C

 ='[仓库PMS周38.xls]总PMS'！
 
 
˚F
 
 
Hello



I have a workbooks 



Warehouse PMS Week 36


Warehouse PMS Week 37


Warehouse PMS Week 38




Then i have a sheet with table like that 





A       B          C        D                    E
Week Planned	Actual	Reason			Action Comment		
35	 #REF!	 #REF!							
36	 #REF!	 #REF!							
37	 #REF!	 #REF!							
38	 #REF!	 #REF!							
39	 #REF!	 #REF!							




Each the REF in Column B contening 
='[Warehouse PMS Week 37.xls]Total PMS'!$E$113


And in Colum C 
='[Warehouse PMS Week 38.xls]Total PMS'!$F$113




now i want to do something like that i want to replace 35 in 
Warehouse PMS Week 35.xls
 With INDIRECT("A2") and so go on but i don't have luck with that and my formula dont work :(



The whole point is i have like 52 weeks and i want link them to this table and get the values from Week Periods im curently in  thats mean in moment when i change the A2:A6 with other nr like 42 or 52 the sheet will link it strate to this workbooks



Any help with That ? or any better solutions
解决方案
E

113

And in Colum C

='[Warehouse PMS Week 38.xls]Total PMS'!

F


                        
这篇关于使用间接功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！