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

½Ð°ÝVLOOKUP¦³¿ìªk¥Î¬YÄæ¸Ì³¡¥÷¤@¼Ëªº¦r¤¸¥h¤ñ¹ï§ä¨ì¸ê®Æ¶Ü? ÁÂÁÂ!

½Ð°ÝVLOOKUP¦³¿ìªk¥Î¬YÄæ¸Ì³¡¥÷¤@¼Ëªº¦r¤¸¥h¤ñ¹ï§ä¨ì¸ê®Æ¶Ü? ÁÂÁÂ!

VLOOKUP(A1,»ù!A:D,4,FALSE)

¦p¥Î¬YÄæA1="¼s¿n¬ì§ÞªÑ¥÷¦³­­¤½¥q"
¥h¤ñ¹ï§ä¨ì¥t¤@¤u§@ªíªºD¸ê®Æ,¦ý¥t¤@¤u§@ªíªºA¬O"¼s¿n",
½Ð°Ý¦³¿ìªk§ï¦¨A1¥u¦³³¡¥÷²Å¦X¤]§äªº¨ì¸ê®Æ¶Ü?
ÁÂÁÂ!

¥Îªø¦r¦ê§äµu¦r¦ê¡AÀ³¸Ó¤£¦æ¡CÅܳqªº¿ìªk¬O¨úªø¦r¦ê«e­±¤G­Ó¦r¤¸¥h¤ñ¹ï¡C

TOP

¦^´_ 2# ANGELA


    ¦]¬°¦³¨Ç¤½¥q¦WºÙ¨Ã¤£¬O«e2¦r¬Û³q  ©Ò¥H¨ú«e2­Ó¦r¤¸¥h¤ñ¹ï¦³¨Ç¤½¥q·|µLªk§ä¨ì  ¤£¹LÁÙ¬OÁÂÁ±z¤F!

TOP

¦^´_ 3# eric866

=LOOKUP(2,1/(LEN(SUBSTITUTE(A1,Sheet2!A1:A4,""))=LEN(A1)-LEN(Sheet2!A1:A4)),Sheet2!D1:D4)

   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o¤]¥i¥H§ä¨ì~ ¯u¯«©_  ¯uªºÁÂÁÂHsiehª©¥D¼·ªÅ¸Ñµª!

TOP

ªGµM¬O¦n¤èªk¡A¾Ç²ß¤F¡C

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-9-17 08:24 ½s¿è

¤½¦¡¥i¥Hµu¤@点 :

=LOOKUP(,-FIND(Sheet2!A1:A4,A1),Sheet2!D1:D4)
1

µû¤À¤H¼Æ

TOP

¤]ÁÂÁ±zªº¸Ñµª~ ¥u¬O§Úµo²{¦ü¥G¤£¯à¥Î¾ã¦C(A:A)©Î­­©w°Ï°ì¤º(A1,A10)§äªº¤è¦¡,µ¥©ó»¡¶W¹L¤F(A1:A4)´N§ä¨ìªº¸ê®Æ·|ÅÜ0,³o¦b±`±`§ó·sªº¸ê®Æ¤W·|Åܪº«Ü³Â·Ð!

TOP

¤]ÁÂÁ±zªº¸Ñµª~ ¥u¬O§Úµo²{¦ü¥G¤£¯à¥Î¾ã¦C(A:A)©Î­­©w°Ï°ì¤º(A1,A10)§äªº¤è¦¡,µ¥©ó»¡¶W¹L¤F(A1:A4)´N§ä¨ìªº ...
eric866 µoªí©ó 2012-9-18 15:17


§ó§ï¬°

=LOOKUP(,-FIND(Sheet2!A1:INDEX(Sheet2!A:A,MATCH("*",Sheet2!A:A,-1)),A1),Sheet2!D1:INDEX(Sheet2!D:D,MATCH("*",Sheet2!D:D,-1)))

TOP

¦^´_ 9# JBY


«D±`ÁÂÁ±zªá®É¶¡À°§Ú¸Ñµª~´X­Ó¦WºÙ¤j³£§äªº¥X¨Ó,¦ý§Ú¥t¥~¥Î¤j¶q¸ê®Æ¥h§ä¦ü¥G§ä¤£¥X¨Ó©Î¦³¿ù,§Ú¤]¤£ª¾¹D¬O§_§Ú¨º¸Ì¿ù¤F,¤£¹L¨SÃö«Y°Õ~¨ä¹ê§Ú¤w¸g©ñ±ó¥Î³o­Ó¤è¦¡¥h§ä¸ê®Æ¤F,¦]¬°¦³¨Çªø¦WºÙ¤¤¶¡Á٬ﴡ¨ä¥¦¦r,©Ò¥H«ç¼Ë¤]¤£¥i¯à§äªº¨ì¥L¤F,¤£¹LÁÙ¬OÁÂÁ±z¤F! excelÁöµM¦n¥Î,¦ý¤Ó½ÆÂø¤F,¾Ç²ß¦±½u­nªá«Üªø!

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD