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

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

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

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

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

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD