EVALUATE()可以解決你的問題:
http://www.vertex42.com/ExcelArticles/evaluate-function.html
Good luck!
回複:回複:有Excel高手幫我想個招兒,VLOOKUP(C5,[2010.xlsx]Jun!$A$1:$C$185,3,FAL
所有跟帖:
• VLOOKUP(C5,INDIRECT("[2010.xls]" &A1 & “!$A$1:$C$185”),3,FAL -kdkboy- ♂ (79 bytes) () 07/19/2010 postreply 01:45:41