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

VLOOKUP¨ç¼Æ¯à§ä¥X²Ä¤@µ§²Å¦Xªº¸ê®Æ,½Ð°Ý¦³¿ìªk§ä¥X²Ä2,3µ§¶Ü?

VLOOKUP¨ç¼Æ¯à§ä¥X²Ä¤@µ§²Å¦Xªº¸ê®Æ,½Ð°Ý¦³¿ìªk§ä¥X²Ä2,3µ§¶Ü?

§Úª¾¹DVLOOKUP¤]¥i¥H±q«á­±§ä°_,¦ý¤@¼Ë¥u¯à¤@µ§,¦ý¦pªG¬OÂæb¤¤¶¡ªº¸ê®Æ´N§ä¤£¨ì¤F!

VLOOKUP¨ç¼Æ¯à§ä¥X²Ä¤@µ§²Å¦Xªº¸ê®Æ,½Ð°Ý¦³¿ìªk§ä¥X²Ä2,3µ§¶Ü?
µª®×¬O¥i¥Hªº¡A¦ý«Ü³Â·Ð¡A¤@¯ë³£§ï¥ÎINDEX+SMALL¥h³B²z¡C

TOP

¦^´_ 2# ANGELA


    ¨º¥i¥H½Ð°Ý¬O¤°»ò¤èªk¶Ü? ¬O°}¦C¤½¦¡¶Ü?

TOP

¦^´_ 3# eric866

¤½¦¡©ÎªÌ¥ô¦ó¾Þ§@¥i¯à·|»P¸ê®Æªí¤Î¸ê®Æ«¬ºA¤£¦P¦Ó¦³³B²z¤Wªº®t²§
½Ð¤W¶ÇÀÉ®×»¡©ú§Aªº°ÝÃD
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    1.rar (132.37 KB)

±z¦n~¤w¤W¶Ç!  ´N¬O¦p¤º¦³¿ìªk§ä¥X²Ä2©Î3µ§³Ì·s¸ê®Æ¶Ü?  ÁÂÁÂ!

TOP

¦^´_ 5# eric866
1.zip (172.54 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

HsiehªO¥D±z¦n~ÁÂÁ±zªº¶O¤ß¸Ñµª! §Ú¦³¤U¸ü¤F,¥u¬O§Úµoı­Y¬d¨ì2µ§¸ê®Æ¥H¤W¸ê®Æ¦ü·|¤£²Å£°(§Ú¥h"¨Ó·½"¤ñ¹ïªº),·|¤£·|¬O§Ú"¨Ó·½"«á­±¦³«ØLOOKUP¤Ï¦V¬d¸ß°ÏªºÃö«Y?

TOP

¦^´_ 7# eric866


    B4:E4°}¦C¤½¦¡
=IF(INT((COLUMN(A$1)-1)/4)+1>COUNTIF(¨Ó·½!$A:$M,¥Ó³ø!$A4),"",INDEX(¨Ó·½!$A:$M,SMALL(IF(¨Ó·½!$A$15:$M$827=¥Ó³ø!$A4,ROW($15:$827),""),INT((COLUMN(A$1)-1)/4)+1),{6,8,9,13}))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¶â ½T¹ê¬O¥i¥H¤F~¥u¬O§Ú·Q¤£¨ì·|¨º»ò½ÆÂø!
¤£ª¾¹D³o­nªá¦h¤Ö®É¶¡¤~¥i¥H·Q¥X¨Ó? §Æ±æ¤£·|®ö¶O±z¤Ó¦h®É¶¡!  
Á`¤§~ÁÂÁÂHsiehª©¥D±z¤F!

TOP

ÁöµM¬Ý¤£À´,
¦ý¬O§ÚÁÙ¬O·|Ä~Äò¤U¥hªº¾Ç²ß
¤j®a¦n§Æ±æ¶QÄ_¦a¯à°÷¦³¤j¤j´£Äâ¤p§Ì

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD