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

Ãö©ó¨ç¼Æmatch»P®æ¦¡³]©w°ÝÃD

Ãö©ó¨ç¼Æmatch»P®æ¦¡³]©w°ÝÃD

½Ð°Ý¦U¦ì¥ý¶i:
    ¨Ï¥Îvba¤U¸üºô­¶¸ê®Æ(¤@²Õ¼Æ¾Ú¸ê®Æ ®æ¦¡¤@¯ë¬°³q¥Î®æ¦¡)
    ·í§Q¥Îmatch¨ç¼Æ®É «oµo¥Í¿ù»~  ½Ð°Ý¦p¦ó§ó§ïsheet1 aÄæ®æ¦¡¨Ó°t¦Xsheet2 hÄæ®æ¦¡
    ÁÂÁÂ!

TEST.rar (86.53 KB)

TEST.rar (86.53 KB)

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2013-11-28 07:14 ½s¿è

¦^´_ 1# ten999
=MATCH(A2&"",Sheet2!H:H,0)
HÄæ±q¤½¦¡Mid¨Ó¡A¬°¤å¦r¡A
¬GAÄæ¼Æ­È»Ý¥ýÂà¤å¦r¡A¤~¯àmatch¡C

TOP

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