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

[µo°Ý] ½Ð°Ý¥i¥H¥u¤ñ¹ï¤@Äæ¸Ìªº¬Y¨Ç¦r¦Ó§ä¥X¨Ó¶Ü?

[µo°Ý] ½Ð°Ý¥i¥H¥u¤ñ¹ï¤@Äæ¸Ìªº¬Y¨Ç¦r¦Ó§ä¥X¨Ó¶Ü?

·s¼WMicrosoft Excel ¤u§@ªí.rar (36.77 KB)

=VLOOKUP(B1,·s»D!A:B,2,FALSE)

¦p¥ÎVLOOKUP¤ñ¹ï,¥u­n¨Ó·½ªºÄæ(·s»D!AÄæ)¸Ì¦³³¡¥÷¦r²Å¦X­n¤ñ¹ïªºÄæ(B1),´N¥i¥H§ä¥X¨ÓÅã¥Ü*   ¥¿±`¬O­n¾ãÄæ¥þ³¡²Å¦X  ¤£ª¾¹D¥i¥H§ï¦¨³¡¤À²Å¦X¶Ü?

ÁÂÁÂ!

¥»©«³Ì«á¥Ñ ´Ñ»y³¾»ï ©ó 2011-8-4 20:31 ½s¿è

¦^´_ 1# eric866


    ¸Õ¤@¤U±NB1§ï¦¨"*"&B1&"*"¡A¬Ý¬Ý
=VLOOKUP("*"&B1&"*",·s»D!A:B,2,FALSE)<==³o¼Ë
¦pªG­n§ì·s»Dªº¸Ü¬õ¦r2­n§ï¦¨1¤~§ìªº¨ì¡A°£«DÃöÁä¦r¦bAÄæ·s»D¦bBÄæ!
·s¼WMicrosoft Excel ¤u§@ªí.rar (40.91 KB)

TOP

¦^´_ 2# ´Ñ»y³¾»ï


    ­C~ ¥i¥H£z£°  «D±`·PÁÂ! !  ¦Û¤v§ä¥i¯à­n§ä¨ìºÆ¤F , ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD