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