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

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú¤£¦P¤u§@ªíªºÄæ¦ì¦C¦L?

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú¤£¦P¤u§@ªíªºÄæ¦ì¦C¦L?

¦pªþÀÉ¡AÁÂÁÂ! Book3.rar (1.79 KB)

·PÁÂHsieh¤j¤jªº«üÂI¡A¸Ñ¨M§Ú«Ü¤jªº§xÃø¡A·PÁÂ! (¤]ÁÂÁÂANGELA¤j¤j)

TOP

¶i¶¥¿z¿ï«Ü¦n¥Îªº
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

A2=IF(Sheet2!D2<>"",Sheet2!D2,"")
B2=IF(A2<>"",VLOOKUP(A2,IF({1,0},Sheet2!$D$2:$D$9,Sheet2!$C$2:$C$9),2,),"")
C2=IF(A2<>"",VLOOKUP(A2,IF({1,0},Sheet2!$D$2:$D$9,Sheet2!$B$2:$B$9),2,),"")

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD