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

¤ñ¹ïªº¤è¦¡¶×¤J³Ì¤jªº¤é´Á

¤ñ¹ïªº¤è¦¡¶×¤J³Ì¤jªº¤é´Á

ª©¤j±z¦n
§Ú¦³¤@¥÷¤W¤dµ§¸ê®Æ¡A§Ú·Q­n¥Î¤ñ¹ïªº¤è¦¡¶×¤J³Ì¤jªº¤é´Á

°ÝÃD¤@
§Ú­n¦p¦ó§âSheet2¤¤¡A¤å¦r®æ¦¡Âন¤é´Á®æ¦¡

°ÝÃD¤G
Sheet1»PSheet2¤ôªG¦WºÙ¤ñ¹ï«á¡A¶×¤J³Ì¤jªº¦³®Ä´Á¤é´Á©óSheet1¤¤

Àɮצpªþ¥ó
ÁÂÁÂ!!

Book1.rar (7.44 KB)

Book1.rar (7.44 KB)

¤@.
=MAX(INDEX(Sheet2!C:C,SMALL(IF(Sheet2!$A$1:$A$22=Sheet1!A2,ROW($1:$22),999),ROW($1:$10)))) °}¦C¤½¦¡
¤G.
=TEXT(SUBSTITUTE(B2,"/",)+19110000,"0000-00-00")

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-6 14:18 ½s¿è

ª©¥D
=MAX(INDEX(Sheet2!C:C,SMALL(IF(Sheet2!$A$1:$A$22=Sheet1!A2,ROW($1:$22),999),ROW($1:$10))))
§Ú¸ÕÅ窺µ²ªG¤£¯à¥Î~~~
½Ð¥ý¤F¸Ñ°ò¥»ªº°}¦C¤½¦¡¿é¤Jhttp://forum.twbts.com/thread-1277-1-1.html

TOP

ª©¤j
§Ú©¿²¤¤F!!
ÁÂÁÂ
¾Ç²ß´r§Ö

TOP

¦^´_ 3# pupai
§å¶q§ó§ï¦¨¥¿½T¤é´Á¥i¨Ï¥Î¸ê®Æ­åªR
test.gif
³Ì¤j¦³®Ä¤é´Á
B2=IF(COUNTIF(Sheet2!A:A,A2)>0,LOOKUP(A2,Sheet2!A:A,Sheet2!B:B),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Ú¥Îªº¤èªk·|¦h¥Î¤@¨ÇÀx¦s®æ

Book1 - ½Æ»s.rar (8.33 KB)

YOYO

TOP

¤å¦rªº¤¤µØ¥Á°ê¤é´Á§ï¦è¤¸¤é´Á,¥ÎÁª©¥Dªº¸ê®Æ­åªR¤~¬O¤ý¹D.²³æ©ö¥Î.

TOP

¦^´_ 5# Hsieh


½Ð°ÝªO¤j
³Ì¤j¦³®Ä¤é´Á
B2=IF(COUNTIF(Sheet2!A:A,A2)>0,LOOKUP(A2,Sheet2!A:A,Sheet2!B:B),"")
§ÚµLªk±a¥X¥¿½Tªº³Ì¤j¦³®Ä¤é´Á­C
YOYO

TOP

ªO¤j
§Ú¤]±a¤£¥X¨Ó

TOP

¦^´_ 9# pupai


    ©êºp!¨S¬Ý²M·¡SHEET2¤é´Á¨S¦³±Æ§Ç
B2°}¦C¤½¦¡
{=MAX(IF(Sheet2!$A$2:$A$22=Sheet1!A2,Sheet2!$B$2:$B$22,""))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD