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

[µo°Ý] ´M§ä¤p°ÝÃD

[µo°Ý] ´M§ä¤p°ÝÃD

Dear¤j¤j­Ì:

¥Î¤F index ©Î vlookup³£¦³°ÝÃD¡A·Q»¡¸ò¬Ý¤£¨£ªº¦r¤¸¬O§_¦³Ãö¡A¤]°µ¨ú¥N¤F¡C
¦ýÁÙ¬O¥X¿ù¡C

·Ð½Ð¸Ñ´b
·PÁÂ

¦pªþÀÉ

´M§ä°ÝÃD.zip (7.05 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-9-18 08:20 ½s¿è

¦^´_ 1# jj369963
1¡BSheet1¤§AÄæ¨C¤@µ§¸ê®Æ¤§³Ì¥ªºÝ¤ñSheet2¤§AÄæ¸ê®Æ¦r¤¸¼Æ¦h1­Ó¦ì¤¸¡A¬G¹Bºâµ²ªG¬°#N/A¡C
2¡B¨Ì1#ªþÀɭ즳ªº¤½¦¡­×§ï
Sheet2¤§Àx¦s®æB2½Ð¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=INDEX(Sheet1!B$2:B$6,MATCH($A2,TRIM(Sheet1!$A$2:$A$6),0))
¦V¥k¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# jj369963

¦³®É¨Ó·½¸ê®Æ«e«á·|¦³§¨´í¡A¥i¥H¥Î ¸U¥Î¦r¤¸³B²z
=VLOOKUP("*"&$A2&"*",Sheet1!$A:B,COLUMN(B1),)

¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD