excel获取工作表名称

Vivant

1. https://jingyan.baidu.com/article/1612d5004143ede20e1eeefd.html
   
2.       
   
3.     =INDEX(GET.WORKBOOK(1),ROW(目录!IV3)&T(NOW()))
   
4.       
   
5.     =IFERROR(HYPERLINK(表名&"!A2",MID(表名,FIND("]",表名)+1,99)),"")
   
6.       
   
7.     =HYPERLINK("#目录!A1","返回目录")
   
8.       
   
9. 
   
10.     =IF(ISERROR(VLOOKUP(A4,[XXXX.xlsx]XXXX!$A$3:$A$39,1,FALSE)),"",(VLOOKUP(A4,[XXXX.xlsx]XXXX!$A$3:$A$39,1,FALSE)))
    
11. 
    
12.     =IF(ISERROR(
    
13. 
    
14.     ),"",

复制代码