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

[µo°Ý] ¨D¶l»¼°Ï¸¹¦Û°Ê¿é¤Jvlookup°ÝÃD

[µo°Ý] ¨D¶l»¼°Ï¸¹¦Û°Ê¿é¤Jvlookup°ÝÃD

¶l»¼°Ï¸¹¦Û°Ê¿é¤J.rar (18.54 KB)
¸g±`¿é¤J¦a§}®É»Ý­n¬d¸Ó¦a§}ªº¶l»¼°Ï¸¹¡Aı±o«Ü³Â·Ð¡A
²{¤w¦³¦a°Ï¤Î¶l»¼°Ï¸¹¹ï·Óªí¡A·í¿é¤J¦a§}®É¦Û°Êvlookup¿é¤J¦a§}ªº«e5­Ó¦r¡AÅý¥¿½Tªº¶l»¼°Ï¸¹¦Û°Ê²£¥Í¡A¦ý¬O¤£ª¾¬°¦ó¨S¿ìªk¤ñ¹ï¥¿½T¡A½Ð±Ð°ª¤â«üÂI

°ÝÃD¦pªþ¥ó
robin

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-8-31 06:38 ½s¿è
¸g±`¿é¤J¦a§}®É»Ý­n¬d¸Ó¦a§}ªº¶l»¼°Ï¸¹¡Aı±o«Ü³Â·Ð¡A
²{¤w¦³¦a°Ï¤Î¶l»¼°Ï¸¹¹ï·Óªí¡A·í¿é¤J¦a§}®É¦Û°Êvl ...
newlink µoªí©ó 2014-8-30 23:10

1. ¬JµM§A¤ñ¹ïªº°ò·Ç¬OLEFT(E2,5),
¨º»ò§Aªº¹ï·Óªí¤º®e´N³£¥u¯à¬O 5 ­Ó¤¤¤å¦r,
¦]¬° VLOOKUP ªº¤ñ¹ï¬O §¹¥þ ¤å¦r¤ñ¹ï¦Ó«D ³¡¤À ¤å¦r¤ñ¹ï.
§Y«K§A¨Ï¥Îªñ¦ü­È¤ñ¹ï¤]½Ð±N ¹ï·Óªí ¥þ³¡³£§ï¬° 5 ­Ó¤¤¤å¦r,
³o¼Ëµ²ªG¤~·|¥¿½T.

2. ¤½¦¡§A­n§ï¦¨ =IF(E2="","",VLOOKUP(LEFT(E2,5),$A$2:$B$100,2,0)) ¤~¥i¥H,
Range_lookup ÅÞ¿è­È­Y³]¬° 1 ©Î True ®Éªº¤ñ¹ï¬O ªñ¦ü­È ¤ñ¹ï,
¦Ó¥B§Aªº ¹ï·Óªí ¥²¶·¬O¸g¹L »¼¼W±Æ§Ç ¹Lªº, (¤]´N¬O­n¥Î ¦a°Ï ¬°Áä­È, °µ »¼¼W±Æ§Ç )
³o¼Ë¥X¨Óªºµ²ªG¤~·|¬O¥¿½Tªº.
¶l»¼°Ï¸¹¦Û°Ê¿é¤J-a.zip (9.27 KB)

¨Ï¥Îªñ¦ü­È¤ñ¹ïÁÙ¦³­Ó¯ÊÂI,
¨º´N¬O´Nºâ§ä¤£¨ì²Å¦Xªº¸ê®Æ,
¥¦·Ó¼Ë·|µ¹§A¤@­Ó¼Æ¾Ú,
³o¼Ë´N¨S¦³ÀËÅç¸ê®Æ¥¿½T©Êªº¥\¯à¤F.

³Ì«á, ³o¸Ì¬O°Q½× Excel VBA µ{¦¡ªºª©,
µo¦b Excel ¤@¯ë°Ï ¤ñ¸û²Å¦X°Q½×ª©¥»¨­¥DÃDªº»Ý¨D.

TOP

«D±`·PÁ¡A¦hÀ´¤F¤@¨Ç¡C
robin

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD