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