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

vlookup ¬dªí°ÝÃD

vlookup ¬dªí°ÝÃD

¥»©«³Ì«á¥Ñ yc1031 ©ó 2012-1-30 15:57 ½s¿è

·Q½Ð°Ý¦U¦ì ¦³Ãö©óvlookup ¬dªíªº°ÝÃD

§Ú·|¾Þ§@¤@¯ëªºvlookup, ¦ý§Ú²{¦b¹J¨ìªº±¡§Î¬O

¨Ò¦p¤@­Ó­q³æ½s¸¹¸Ì ­q¦³¤G¶µ²£«~, §Ú·Q­nvlookup®É , ²Ä¤@¶µ²£«~¹ï·Ó¬O¨S¦³°ÝÃD, ¦ý§Ú­n«ç»ò§ä¥X²Ä¤G¶µ²£«~ªº¸ê®Æ, §Ú¸Ó«ç»ò¹B¥Î©O?    ·PÁÂ!

¥¼©R¦W.jpg (11.66 KB)

¥¼©R¦W.jpg

¦^´_ 12# register313


    ¤Ó·PÁ¤F! :)
¦¨¥\Åo

TOP

¦^´_ 10# ANGELA

ÁÂÁ¹D¯},¤£µM§Ú·Q¯}ÀY¤]¤£ª¾«ç¸Ñ!¨ü±Ð!!

TOP

¦^´_ 11# yc1031

Á`ªí ¤u§@ªí


¬d¸ß ¤u§@ªí

B2=INDEX(Á`ªí!B:B,SMALL(IF(COUNTIF($A$2,Á`ªí!$A$2:$A$10)>=1,ROW($2:$10),65534),ROW(A1)),)&""   °}¦C¤½¦¡

Book1.rar (4.05 KB)

TOP

¦^´_ 9# ANGELA


    ¦¨¥\¤F! ÁÂÁ±zªº¨ó§U~

·Q¦A½Ð°Ý¤@¤U, ­Y§Ú­n¸óªí¬d¸ß, ´N¬OÁ`ªí¬O¦b¥t­Ó¤u§@ªí, ¨º§Ú¸Ó¦p¦ó§ï©O?

TOP

¦^´_ 7# PJChen


    index ¤¤ªºsmall¬O­n¦b²Å¦X±ø¥óªº°}¦C¤¤¨ú¥X¥Ñ³Ì¤p¶}©l¨ì³Ì¤jªº­È¡C

TOP

¦^´_ 8# yc1031


    °}¦C¤½¦¡¿é¤J­n¥Îctrl+shift+enter¤TÁä¤@°_«ö¡A·|¦Û°Ê¥X²{¤j¬A¸¹

TOP

¦^´_ 5# register313


   §Ú­è¸ÕµÛ§Ë¤@¼ËªºªF¦è, ¦ýÁÙ¬O¶]¤£¥X¨Ó, ¬O§_¥i¥H½Ð±z¬Ý¤@¤U, §Ú­þ¸Ì¦³§Ë¿ù¶Ü? ·PÁÂ!

µª®×ªÅ¥Õ.JPG (47.98 KB)

µª®×ªÅ¥Õ.JPG

TOP

¦^´_ 6# ANGELA

§Ú±`¬Ý¨ìindex»Psmall©ñ¦b¤@°_¨Ï¥Î,½Ð°Ý§@¥Î¬O¤°»ò?

TOP

¦^´_ 3# PJChen


        =INDIRECT("C"&SMALL(IF($A$2:$A$5=D2,ROW($A$2:$A$5),""),COUNTIF($D$1:D1,D2)+1))
    ¤½¦¡¤Óªø¬O¤ñ¸ûÃø¤F¸Ñ.¥i¥Hµ½¥ÎEXCELªº¤½¦¡½]®Ö,¥t¥~¤]¥i¥Î¤Ï¥Õ¤½¦¡¤¤¦P¤@²Õ¬A©·¦A«öF9ºCºC®ø¤Æ¤½¦¡ªº¹B§@¡C

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD