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

[µo°Ý] ¦p¦ó¨D¥X¬Û²Å¤§­È,¬O¥ÎVLOOKUPÁÙ¬O¥t¦³¨ä¥L¤èªk

[µo°Ý] ¦p¦ó¨D¥X¬Û²Å¤§­È,¬O¥ÎVLOOKUPÁÙ¬O¥t¦³¨ä¥L¤èªk

·Q½Ð±Ð¦U¦ì°ª¤â:
¦pªþ¥óFÄæ©Ò¦C¤½¦¡¨D¥XAÄæ»PIÄæ¬Û²Å¨Ã¦C¥XKÄ椧­È,
­n°Ýªº¬OGÄ椽¦¡¦p¦ó¨D¥XAÄæ»PLÄæ¬Û²Å¨Ã¦C¥XNÄ椧­È,(¤]´N¬OAÄæ¥N¸¹¯à¥¿½T¤ñ¹ï¥XLÄæ¥N¸¹¨Ã¦C¥XLÄ椧¼Æ¾Ú)
³Â·Ð¦U¦ì°ª¤â¤F,ÁÂÁÂ!


60¤é³Ð·s°ª-vlookup.rar (4.38 KB)

60¤é³Ð·s°ª-vlookup.rar (4.32 KB)

¦^´_ 1# long8448


    G2==IF(COUNTIF($L$2:$L$8,$A2)=0,"",VLOOKUP(A2,$L$2:$N$8,3,0)) ¦V¤U½Æ»s

60¤é³Ð·s°ª-vlookup.rar (4.5 KB)

boyao

TOP

¦^´_ 2# boyao
¤j~§A¦n¯«³á!¥[¤J½×¾Â¤Î¨ç¼Æ¤]§Ö1¦~¤F,¦ý¬O¯u¥¿¦b¾Ç²ß«o¬O³Ìªñ(¥ý«e³£¨S®É¶¡),³Ìªñ¬Ý®Ñ¶È¾Ç¨Ç¥Ö¤ò,³o­Ó°ÝÃD¦b®Ñ¤¤³£§ä¤£¨ì¬ÛÃö¸Ñµª,ÁÂÁ§Aªº¸Ñ´b,­è­è±N§A©Ò¦Cªº¤½¦¡¸Ô²Ó¬Ý¤F¬Ý,¦A±N¤½¦¡°Ñ·Ó³¡¤Àµy°µ­×§ï¦Ü¨ä¥L¤u§@ªí....... ¨S¿ù,³o´N¬O§Ú­nªºµª®×,¦A¦¸¸ò§A»¡ÁnÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD