excel-day12

indirect函数

 

 

=INDIRECT(E12)

 

 

=INDIRECT("E"&ROW()*5-25)

 

 

=SUM(INDIRECT(G3))

 还用了数据有效性

 

 

 

 

 

=INDIRECT(A4&"!g2")

 

 

 

=VLOOKUP(B$2,INDIRECT($A3&"!$A:$G"),7,0)