ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] vlookup ¦p¦ó¥H³Ì¦Z¤@µ§¸ê®Æ§@¬°¼Ð·Ç

[µo°Ý] vlookup ¦p¦ó¥H³Ì¦Z¤@µ§¸ê®Æ§@¬°¼Ð·Ç

vlookup.rar (1.92 KB)

½Ð±Ð:

vlookup ®É­Y¬Û²Åªº±ø¥ó¦³¦n´X­Ó¡A¤½¦¡³q±`³£¥u·|¥H²Ä¤@­Ó§ä¨ìªº¼Ð·Ç¡A
½Ð°Ý¦³¿ìªk¥H³Ì«á¤@­Ó¬°¼Ð·Ç¶Ü¡H

·P®¦...

¥»©«³Ì«á¥Ñ register313 ©ó 2011-11-29 22:31 ½s¿è

¦^´_ 1# Qin

    B22=LOOKUP(2,1/($A$3:$A$14=A22),$B$3:$B$14)  ¤Þ¥ÎHsieh¶W¯Åª©¥D©ó¤U¦C¤å³¹¤§¤½¦¡
    http://forum.twbts.com/viewthrea ... ighlight=vlookup%2B

TOP

¦^´_ 2# register313


    ¸Õ¤F, ±o¤£¨ìµª®×, ¦A½Ð«e½ú½ç±Ð..

TOP

¦^´_ 3# Qin

123.gif (103.81 KB)

123.gif

TOP

¦^´_ 4# register313

½Ð°Ý¥H¤W°ÊºA(GIF)½d¨Ò¦p¦ó¨î§@?

TOP

§Ú¤ñ¸û·Qª¾¹D¦p¦ó¤@¤f®ð¥[¤J4­Ó©T©w²Å¸¹$

TOP

¦^´_ 6# vvcvc


    «öF4Áä

TOP

¸Õ¦¨¥\¤F
ÁÂÁ¤À¨É¤p§Þ¥©

TOP

¦^´_ 5# Qin
¦^´_ 6# vvcvc

http://forum.twbts.com/viewthread.php?tid=2818&highlight=

¦b½s¿è¤½¦¡®É  ¿ï¾Ü¤½¦¡¤¤Àx¦s®æ¦ì§}  «öF4 ¥i§@¬Û¹ï¦ì§},²V¦X¦ì§},µ´¹ï¦ì§}  ¤§¤Á´«

TOP

¦^´_ 5# Qin


ªíÀY´N¦³¤F,¦Ó¥B¸m³»¤¤   
http://forum.twbts.com/thread-2818-1-1.html
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD