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

[µo°Ý] ¦h±i¤u§@ªí´M§ä¹ïÀ³­È¡A¨D¨ç¼Æ¡H

[µo°Ý] ¦h±i¤u§@ªí´M§ä¹ïÀ³­È¡A¨D¨ç¼Æ¡H

¥»©«³Ì«á¥Ñ ¹q·xÄl ©ó 2015-1-19 22:41 ½s¿è

sheet1:
AÄæ----BÄæ
Ä«ªG---50¤¸
¤õÀsªG-80¤¸
ªÝ¼Ö---40¤¸
­»¿¼---25¤¸

sheet2:
AÄæ----BÄæ
¤ô»e®ç--120¤¸
¦è¥Ê----150¤¸
«¢»e¥Ê--180¤¸

¥H¦¹Ãþ±À
¦@¤­±i¤u§@ªí¡A¤À§O¬°sheet1¡Bsheet2¡Bsheet3¡Bsheet4¡Bsheet5
¬d§ä¤­±i¤u§@ªíAÄæ(A:A)¹ïÀ³¤§B(B:B)Äæ
¦b²Ä¤»±i¤u§@ªíAÄæ¿é¤J¤ôªG¦W¡ABÄæ§Y¥i±a¥X»ù¿ú
sheet6:
AÄæ¿é¤J¤ôªG¦W¡ABÄæ±a¥X»ù¿ú
ex:
AÄæ----BÄæ
­»¿¼---25¤¸
¦è¥Ê---150¤¸

¨Dsheet6¡ABÄæ¨ç¼Æ¡H

¦^´_  fantersy


    Sorry!­è¤S¦A½T»{¤@¦¸~¦³»~~½Ð¤£­n¥Î!!ÁÂÁÂ!!
fantersy µoªí©ó 2015-1-20 16:17



    ¸Õ¸Õ¬Ý¦bSheet6! ¤À­¶ªºB2¿é¤J
=IF(COUNTIF(Sheet5!A:A,$A2),VLOOKUP($A2,Sheet5!$A:$B,2,0),IF(COUNTIF(Sheet4!A:A,$A2),VLOOKUP($A2,Sheet4!$A:$B,2,0),IF(COUNTIF(Sheet3!A:A,$A2),VLOOKUP($A2,Sheet3!$A:$B,2,0),IF(COUNTIF(Sheet2!A:A,$A2),VLOOKUP($A2,Sheet2!$A:$B,2,0),IF(COUNTIF(Sheet1!A:A,$A2),VLOOKUP($A2,Sheet1!$A:$B,2,0),"")))))

§Æ±æ¥i¥H¥Î...QQ
§Ú´ú¸Õ¹L¥i¥H~¦Ó¥B¬O¥Î¤­­Ó¤À­¶

TOP

¦^´_ 4# fantersy


    Sorry!­è¤S¦A½T»{¤@¦¸~¦³»~~½Ð¤£­n¥Î!!ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2015-1-20 15:44 ½s¿è

¦^´_ 3# ¹q·xÄl


    §Ú¸Õ¬O¥i¥H
http://www.FunP.Net/234864
¤W­±¬O§Ú´ú¸ÕªºÀÉ®×
§Ú¥Î¤F¨â­Ó¤À­¶¥h¼g
¤À­¶¦WºÙ~µª®×´N¬O§Ú¼gªº¤½¦¡....

¥u­n¦bµª®×¤À­¶ ªº¤ôªG¦WºÙAÄæ¤W¼g¤W¤ôªG¦W¦r´N·|¥X²{»ù®æ
·íµM~½d³ò­n¬OSheet1¸òSheet2¦³ªº¤ôªG¦WºÙ...

TOP

¦^´_ 2# fantersy


    §A¸Õ¹L¤F¶Ü¡H¥i¥H¶Ü¡H§Ú¸Õ¦n¹³©Ç©Çªº= =

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2015-1-20 13:58 ½s¿è

¸Õ¸Õ¬Ý¦bSheet6! ¤À­¶ªºB2¿é¤J

=IF(A2="","",VLOOKUP($A2,INDIRECT("Sheet"&ROW(1:1)&"!$A:$B"),COLUMN(),0))

¦³¤@­Ó·|Åܦ¨ªí±¡²Å¸¹=.=||
¬O :+$

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD