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

[µo°Ý] ¦p¦ó¦Û°Ê·j´M¬Y­ÓxlsÀɤºªº¦h­Ó¤À­¶¤º¤§¼Æ­È?

[µo°Ý] ¦p¦ó¦Û°Ê·j´M¬Y­ÓxlsÀɤºªº¦h­Ó¤À­¶¤º¤§¼Æ­È?

§Ú¥Ø«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Åý§Ú¥u­n¿é¤J¹ïªº®Æ¸¹,¥L´N¯à¦Û°Ê·j´M©Ò¦³¤À­¶,§ä¥X²Å¦X±ø¥óªºÄæ¦ì¸ê°T?

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-1-25 12:30 ½s¿è

¥Ø«e§Ú¥Îªº²Â¤èªk¬O¼W¥[¯Á¤Þ¤u§@ªí                       
                       
        A                 B                     C
1        as01         ¶}¤ß­¹«~       
2        as02         ¶}¤ß­¹«~       
3        kksk0123 ªFªF°®Â³       
4        kksk0124 ªFªF°®Â³       
5                       
=IF(B1=0,"",VLOOKUP(B1,INDIRECT("[¸ê®Æ®w.XLS]"&VLOOKUP(B1,[¸ê®Æ®w.xls]¯Á¤Þ!$A:$C,2,)&"!A:B"),2,))
¤u§@ï¸ê®Æ®w­n¶}敫¤~¯à¥ÎINDIRECT¨ç¼Æ

TOP

·PÁ¤j¤j¦^µª,
¤£¹L§Úexcel¤£¬O«Ü±j,
¥i¥H¸Ô²Ó»¡©ú¤@¤U¶Ü?¦³ÂI¬Ý¤£À´,·P®¦

TOP

[i=s] ¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-1-25 11:36 ½s¿è [/i]

¸ê®Æ®w¤u§@ï¼W¥[¤@­Ó¤u§@ªí,¦WºÙ©w¬°¯Á¤Þ
1  as01            ¶}¤ß­¹«~
2 as02             ¶}¤ß­¹«~
3 kksk0123     ªFªF°®Â³
4 kksk0124     ªFªF°®Â³

¦p¤W AÄæ°O¿ý®Æ¸¹    BÄæ°O¿ý¼tµP
§â©Ò¦³ªº®Æ¸¹¤Î¹ïÀ³ªº¼tµP¥þ¥´¤W
¥H¤W°²³]¨â­ÓÀɮצb¦P¤@­Ó¸ê®Æ§¨¤¤,¨Ã¦P®É¶}敫
C1=IF(B1=0,"",VLOOKUP(B1,INDIRECT("[¸ê®Æ®w.xls]"&VLOOKUP(B1,[¸ê®Æ®w.xls]¯Á¤Þ!$A:$C,2,)&"!A:B"),2,))
°²³]¬dªº¬Oas01
VLOOKUP(B1,[¸ê®Æ®w.xls]¯Á¤Þ!$A:$C,2,) ·|³Q´À´«¦¨ ¶}¤ß­¹«~
°²³]¬dªº¬Okksk0124
VLOOKUP(B1,[¸ê®Æ®w.xls]¯Á¤Þ!$A:$C,2,) ·|³Q´À´«¦¨ ªFªF°®Â³

TOP

¼Ó¤W¤j¤jªº¤èªk¹ï§Ú¥i¯à¤£¾A¥Î,

1.®Æ¸¹ Á`µ§¼Æ¶W¹L¸Uµ§,¦A¦h¼W¥[¤@­Ó¯Á¤Þ¤u§@ªí±N«~µP¤ÀÃþ¥i¯à¤ÓÁcº¾,¥B³o­Óªí¨C¤@¦~³£¥²¶·§ó·s¤@¦¸»ù®æ,¥i¯à¤uµ{¤Ó¹L¯E¤j
2.¥Ø«e¤ñ¸û§Æ±æ°µ¨ìªº¬Okey¤J®Æ¸¹,¦Û°Ê·j¯Á ¸ê®Æ®wxls. ªº©Ò¦³¤u§@ªí¤ºªº¸ê°T,«~µP­Ë¬O¨ä¦¸

³o¨â¤Ñ¸Õ¹Laccessµo²{¥L¤]¥u¯à·j´M³æ¤@¤u§@ªí¤º¸ê°T,
·Q½Ð°Ý¦pªGexcelªº¨ç¼ÆµLªk°µ¨ì§Úªº»Ý¨D,¨ºvba¥i¥H°µ¨ì¶Ü? tks!!

TOP

¦^´_ 5# kim595


    §Ú»¡¹L¤F¥L¬O¤@­Ó²Â¤èªk­n¼W¥[¤u§@ªí,¬O³Â·ÐÂI,¦ýºÞ¥Î,³o¤½¦¡·|¬D¥¿½Tªº¤u§@ªí¨Ó°µvlookup¤£¥Î¥h¬d¨C­Ó¤u§@ªí.¤W¸UºØ¶µ¥ØÀ³¸Ó¤£¬O°ÝÃD,
    ²£«~½s¸¹­ì¨Ó´N¦³¤Fcopy ¤@¤U«Ü§Öªº.

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-1-25 14:48 ½s¿è

¦pªG®Æ¸¹ªøµu¦³³W«h
¦p
sheet1!b1=as01  >>len(b1)=4
sheet2!b1=kksk0123  >>len(b1)=8
sheet3!b1=aaaa123  >>len(b1)=7
sheet4!b1=ac123f  >>len(b1)=6

¤½¦¡
1) ¬d¸ßªí.xls
   B      C      D
®Æ¸¹ ¢x«~¦W¢x »ù®æ

(¿é¤J¥¿½T®Æ¸¹±a¥X«~¦W³W®æ)
C1ªº¤½¦¡¬°:
=IF(B1="","",VLOOKUP(B1,indirect("C:\Documents and Settings\fuj\
My Documents\[¸ê®Æ®w.xls]"&index({"","","","¶}¤ß­¹«~","5½X","6½X","7½X","ªFªF°®Â³"},,len(b1))&"!$A:$D"),2,0))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

·PÁ¨â¦ì¼ö¤ß¦^µª :D

¦^ª©¥D:
§Æ±æ¥i¥H¶°µ²¤j®aªº·N¨£°µ¥X¤@­Óº}«G¦n¥Îªº¤½¦¡...
®Æ¸¹«Ü¤¾ªø¤]µL¤@©w³W«h,ÀH·N¬D­Ó´X­Óµ¹ª©¥D°Ñ¦Ò~

LBMK7115-ISO
SV1-N4-24VDC
0121A2D
0700K3
14LU316MM
2-RSG-316B
6320G2B
HQC4-D-6M0-316

¥H¤W¬O¥Ñ¤£¦P¼tµPÀH·N¬D¿ï´X¼Ë¹ê»Úªº®Æ¸¹

TOP

Á`¦³­Ó°ò¥»³W«h
¦p¶}¤ß­¹«~¬°"AS"¶}ÀY
ªFªF¬°"KK"¶}ÀY

¦pªG§¹¥þ¨S¦³³W«h«h©ñ¦b¦P¤@­Ó¤u§@ªí¤è«K³B²z
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 3# kim595

¸ò4#ªº·QªkÃþ¦ü
¤£¹L¥u­n±N©Ò¦³¸ê®Æ®w¤u§@ªí¦WºÙ¦C¥X
±N¸ê®Æ®w¬¡­¶Ã¯¦P®É¶}±Ò

¦hªí¬d¸ß.rar (10.29 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD