有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