ªð¦^¦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

TOP

¦^´_ 2# ANGELA

§Ú¤]¦³¬Û¦P°ÝÃD:
½Ð°Ý¬O§_¯Âºé¥ÎVLOOKUPµLªk±a¥X¤GºØ¤£¦P±ø¥óªºµ²ªG?©Ò¥H­n°Ñ¸Ô¥H¤U°}¦C¤½¦¡?¤£¹L³oºØ½Æ¦X¦¡ªº¤½¦¡«ÜÃø²z¸Ñ,¥i¥H³Â·ÐÁ¿¸Ñ¶Ü?ÁÂÁÂ!
    =INDIRECT("C"&SMALL(IF($A$2:$A$5=D2,ROW($A$2:$A$5),""),COUNTIF($D$1:D1,D2)+1))

TOP

¦^´_ 2# ANGELA [/b


«D±`·PÁ±zªº¦^ÂСC

°²¦p¤£°µ " ªÑ»ù¨Ï¥ÎLARGE§ä¥X¥ªªí(ªÑ»ù)«e¤T¦W"³o­ÓÄæ¦ìªº¸Ü,  §Ú­n«ç»ò§ä¥X, ¬Û¦PªÑ»ùªº©O? ´N¬Oª½±µSHOW ·Q­n±o¨ìªºµª®×¡C ·PÁÂ!

TOP

¦^´_ 1# yc1031

E2=INDEX(B:B,SMALL(IF(COUNTIF($D$2,$A$2:$A$10)>=1,ROW($2:$10),65534),ROW(A1)),)&""     °}¦C¤½¦¡



Book1.rar (1.66 KB)

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

¦^´_ 6# ANGELA

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

TOP

¦^´_ 5# register313


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

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

µª®×ªÅ¥Õ.JPG

TOP

¦^´_ 8# yc1031


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

TOP

¦^´_ 7# PJChen


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

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD