回複：有Excel高手幫我想個招兒，VLOOKUP(C5,[2010.xlsx]Jun!$A$1:$C$185,3,FALSE)

google vba

所有跟帖： 

• Excel macro and programming? That is a long course. Thanks -色大膽小- ♂ (0 bytes) () 07/17/2010 postreply 10:55:14

• 回複：回複：有Excel高手幫我想個招兒，VLOOKUP(C5,[2010.xlsx]Jun!$A$1:$C$185,3,FAL -peterlution- ♂ (114 bytes) () 07/18/2010 postreply 07:21:27

• VLOOKUP(C5,INDIRECT("[2010.xls]" &A1 & “!$A$1:$C$185”),3,FAL -kdkboy- ♂ (79 bytes) () 07/19/2010 postreply 01:45:41