有Excel高手帮我想个招儿,VLOOKUP(C5,[2010.xlsx]Jun!$A$1:$C$185,3,FALSE)
所有跟帖:
• 回复:有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