有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