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