§Ú¥Ø«e¦³¨âÓxlsÀÉ
(1) ¬d¸ßªí.xls
B C D
®Æ¸¹ ¢x«~¦W¢x »ù®æ
1
(¿é¤J¥¿½T®Æ¸¹±a¥X«~¦W³W®æ)
C1ªº¤½¦¡¬°:
=IF(B1=0," ",VLOOKUP(B1,'C:\Documents and Settings\fuj\My Documents\[¸ê®Æ®w.xls]¶}¤ß¹«~'!$A$1:$D$65536,2,FALSE))
¡°¬õ¦rªº³¡¤À¥u¯à¿ï¤@Ó¤À¶?
(2) ¸ê®Æ®w.xls (¤º¦³¤À¶ Sheet1,Sheet2,Sheet3,Sheet4 ¦U¬°¤£¦P«~µP)
Sheet1 (¶}¤ß¹«~)
®Æ¸¹ ¢x«~¦W¢x »ù®æ
as01 «¢»e¥Ê¿}ªG $15
as02 ¦è¥Ê²¢µ© $50
===================
Sheet2 (ªFªF°®Â³)
®Æ¸¹ ¢x«~¦W¢x »ù®æ
kksk0123 Âø³»æ°® $75
kksk0124 ¬µÂû¬v¬ò¤ù $90
===================
¦]¬°¦U¼tµP¸ê®Æ®w¤ñ¼Æ²³¦h,©Ò¥H¤£§Æ±æ±N¦hÓ¤À¶¦X¨Ö¦¨¤@Ó¤jªº¤u§@ªí,
¦³¨S¦³¤°»ò¤èªkÅý§Ú¥un¿é¤J¹ïªº®Æ¸¹,¥L´N¯à¦Û°Ê·j´M©Ò¦³¤À¶,§ä¥X²Å¦X±ø¥óªºÄæ¦ì¸ê°T? |