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

我這裏麵的Jun是隨月份變的，到七月就是Jul.有辦法讓它跟據另外一個CELL裏的日期自動變嗎？謝

所有跟帖： 

• 回複：有Excel高手幫我想個招兒，VLOOKUP(C5,[2010.xlsx]Jun!$A$1:$C$185,3,FALSE) -TongYouWu- ♂ (10 bytes) () 07/17/2010 postreply 07:10:55

• 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

• EVALUATE()可以解決你的問題. -peterlution- ♂ (115 bytes) () 07/18/2010 postreply 07:23:59

• Thank. For example one, I got "The function is not valid" -色大膽小- ♂ (51 bytes) () 07/18/2010 postreply 15:54:32