- ©«¤l
- 42
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 0
- µù¥U®É¶¡
- 2010-12-12
- ³Ì«áµn¿ý
- 2019-6-8
|
¤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·Qn§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²{") |
|