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

[µo°Ý] ²£«~ºØÃþªí,¸ê®Æ¶¶§Ç¤Î±Æ¦C

[µo°Ý] ²£«~ºØÃþªí,¸ê®Æ¶¶§Ç¤Î±Æ¦C

¥»©«³Ì«á¥Ñ kan109 ©ó 2010-11-9 13:51 ½s¿è

»s§@¨®²£«~ºØÃþªí,¸ê®Æ¶¶§Ç¤Î±Æ¦C
file:sample1234

sheet1 AÄæºØÃþ , BÄ櫬¸¹ , CÄæ¦~¥÷ D/EÄ欰²£«~¨Ï¥Îªº«¬¸¹
(Sheet2 A-H ªºAB1-7/ABC ¬°µ¥¯Å¦@¦³8­Óµ¥¯Å¦bsheet1¥u·|Åã¥Ü¥X³Ì¾A¦X¨â´Úµ¥¯Å)
§Ú¤w¸g§âµ¥¯Å¶¶§Ç¦C©óSheet2(a2:h1450)
§Æ±æ°µ¨ìsheet1 D,EÄ榳ªº«¬¸¹·|±qsheet2©â¥X¨ÃÅã¥Ü©Ò¦³µ¥¯Å

¨Ò¦pSheet1 D5 (AB3108C) , E5 (AB4108R)
Åã¥Ü¥XSheet2 A49-H49 ªº¸ê®Æ©óG-NÄæ
¦p¦¹Ãþ±À....

¬O§_¥ÎVLOOK ??
sample1234.rar (51.55 KB)

·P¿E!!
excel~ ¾Ç¦n¥L§a

½Ð°Ý§Úªº°Ýªk¬O§_¤£°÷²M·¡..?½Ð«ü±Ð
excel~ ¾Ç¦n¥L§a

TOP

²M·¡¡A¥u¬O¬Ý¤£À´¡C

TOP

°²³]Sheet1 E8 (AB3291C)= Sheet2 C196 (AB3291C)
«KÅã¥ÜSheet2 A196-H196 ªº¤º®e¨ì Sheet1 G8-N8

¥i¥H¶Ü??
excel~ ¾Ç¦n¥L§a

TOP

²M·¡¡A¥u¬O¬Ý¤£À´¡C
oobird µoªí©ó 2010-11-10 23:50



    °²³]Sheet1 E8 (AB3291C)= Sheet2 C196 (AB3291C)
«KÅã¥ÜSheet2 A196-H196 ªº¤º®e¨ì Sheet1 G8-N8

¥i¥H¶Ü??
excel~ ¾Ç¦n¥L§a

TOP

¦^´_ 3# oobird


½Ð°Ý¤p§ÌÀ³¦p¦ó¸Ñ¨M??½Ð«ü±Ð!
excel~ ¾Ç¦n¥L§a

TOP

¬O³o¼Ë¶Ü¡H sample.rar (63.76 KB)

TOP

©w¸q¦WºÙ+¤@¯ë¤½¦¡ sample.zip (86.53 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¨Ï¥ÎVLOOKUP ·f°t ©w¸q¦WºÙ´N¥i¥H§¹¦¨¡A
¤£¹L¡A«Øij±N­n¤ñ¹ïªº¸ê®Æ©ñ¨ì³Ì«e­±¡A¥i§K¥h©w¸q¤@°ï¦WºÙ¡A
©w¸q¦WºÙ PRODUCT = Sheet2!$AH
SHEET1 G8=VLOOKUP($E$8,PRODUCT,COLUMN()-6,0)
¦V¥k©Ô¦Ü SHEET1 N8
¨S¨Æ´N¨Ó³}³}

TOP

¦^´_ 9# fr447446


    ·PÁÂ,·PÁÂ!!
excel~ ¾Ç¦n¥L§a

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD