[µo°Ý] ¦p¦ó¯à¤ñ¹ï¾ã­ÓÀÉ®×

gctsai

½Ð°Ý¦U¦ì¤j¤j

¦p¦ó¯à¤ñ¹ï¾ã­ÓÀÉ®×
AÀɮפº¦³¥|­Ó¬¡­¶(sheet1~sheet4)
§Ú·Q­n±qBÀɮפº¥h¤ñ¹ïAÀɮפºªº¥|­Ó¬¡­¶

=VLOOKUP(A1,[A.xls]Sheet1!$A:$B,2,FALSE)
³o­Ó¥u¯à¤ñ¹ï³æ1­Ó¬¡­¶¦Ó¤w

ANGELA

VLOOKUP°Ñ¼Æ¤£¤ä´©°}¦C.¤W­Óªþ¥ó,¤]³\¦³§Oªº¤èªk.

oobird

§A¥i¦bA.XLS©w¸q4­Ó¦WºÙ¡A³o4­Ó¦WºÙ¬°4­Ó¤u§@ªíªºA,BÄæ¡C¦pXA,XB,XC,XD
BÀɮפ]©w¸q4­Ó¦WºÙ¡A³o4­Ó¦WºÙ¬°¤½¦¡¦p¡G
W=IF(ISNA(VLOOKUP($A1,'A.XLS'!XA,2,0)),"",VLOOKUP($A1,'A.XLS'!XA,2,0))
X=IF(ISNA(VLOOKUP($A1,'A.XLS'!XB,2,0)),"",VLOOKUP($A1,'A.XLS'!XB,2,0))
Y=IF(ISNA(VLOOKUP($A1,'A.XLS'!XC,2,0)),"",VLOOKUP($A1,'A.XLS'!XC,2,0))
Z=IF(ISNA(VLOOKUP($A1,'A.XLS'!XD,2,0)),"",VLOOKUP($A1,'A.XLS'!XD,2,0))
³]©w¦n«á¡ABÀÉ®×Àx¦s®æ¿é¤J¡G=W&X&Y&Z

gctsai

¥ýÁÂÁÂO¤j,¥t¦A½Ð°ÝO¤j
©Ò¿×©w¸qA,BÄæ¬O§_¬O¦b"°Ñ·Ó¨ì"¿é¤J=Sheet1!$AB
¦ÓBÀɮתº©w¸q¤½¦¡¬O§_¤]¬O­n¿é¤J¨ì"°Ñ·Ó¨ì"

gctsai

ÁÂÁÂo¤j,¤w¸g¸Ñ¨M¤F
¥t¥~·Q½Ð°Ý¤@¤U¤j¤j
¦b"°Ñ·Ó¨ì"ªº¤º®e­n¦p¦ó­×¥¿
¦]¬°¥u­n¤@¨ì¤½¦¡´N·|¶]±¼

oobird

¦]¬°¥u­n¤@¨ì¤½¦¡´N·|¶]±¼
¤]³\¦~¬öªºÃö«Y¡A¬Ý¤£À´³o¼Ëªº»y¨¥
§AÀ³¸Ó·r°u¦Û¤vªº¸ê®Æ«¬ºA¿ï¾Üµ´¹ï°Ñ·Ó©Î¬Û¹ï°Ñ·Ó¡C

gctsai

¤j¤j¤£¦n·N«ä,§Ú»¡ªº¤£²M·¡.
¦]¬°§Ú¦b©w¸q®Éªº"°Ñ·Ó¨ì"¤À§O¥Î½Æ»sªº¤è¦¡¶K¤W
W=IF(ISNA(VLOOKUP($A1,'A.XLS'!XA,2,0)),"",VLOOKUP($A1,'A.XLS'!XA,2,0))
X=....
Y=.....
Z=.....
¦]¬°¦³¶K¨ì"W"©Ò¥H·Q­n§R±¼,¦Ó´å¼Ð¤@ÂI¨ì¤½¦¡¤¤­n©¹«e¥h­×§ï±ýÅܦ¨"SHEET1!A1"¦p¤U
W=IF(ISNA(VLOOKUP($A1,'A.XLS'!XA,2,0)),"",VLOOKUP($A1,'A.XLS'!XA,2,0))SHEET1!A1
¥t¥~·Q¦A½Ð°Ý¤@¤U¬°¤°»òBÀÉ®×Àx¦s®æ¿é¤J¡G=W&X&Y&Z«á¦³ªºÀx¦s®æ·|¥X²{"(¤Þ¸¹)¸òµ²ªG,¦Ó¦³ªº¤£·|
¦p"123(§Ú­nªº¬O¤£·|¥X²{")