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

[µo°Ý] ±N¸ê®ÆÂà¦Ü¨ì«ü©wªí®æ

[µo°Ý] ±N¸ê®ÆÂà¦Ü¨ì«ü©wªí®æ

Àµ¨D¦U¦ìEXCEL¤j¯«¡ã
³Ìªñ§Ú¦³100µ§ªº¸ê®Æ¥²¶·Âà¨ì«È¤áªº«ü©wªí®æ¤¤¡]«È¤Hªº®æ¦¡¬O¨C±i¥i¶ñ¤J10µ§¡^

¦ý°ÝÃD¨Ó¤F¡ã¡ã¡ã
¥Ñ©ó­Ó¤Hªºªí®æ³£¬O¿W¥ßªº
§Úªº¸ê®Æ­n¶ñ¤J«È¤Hªºªí®æ¡ã³o¼Ë´N­n¶K100¦¸¡]§¹¥þ©ñ±ó¡^
·Q¼g¤½¦¡¶i¥h¡ã¡ã¡ã
¦ý·Q¤£¥X¥i¥H¤@¦¸®ð¨þ¦¨ªº¤½¦¡....
¦n¹³¤]­n¤ÀÂ_¼g¡ã¡ã¡ã¡ã
¤£ª¾¦³¤°»ò¤j¤j¦³¦n¤èªk¡ã
©Î¥i¥H§Q¥Îªº¤½¦¡
¥i¥H¸`¬ÙÂà´«ªº®É¶¡©O¡H¡H¡H
ÀY¯uªº«Ü¤j¡ã¡ã¡ã¡ã¡ã¡ã
­n¬O¥H«á¦³500µ§«ç¿ì¡ã¡ã¡ã
«È¤H¤S¤@©w­n³o¼Ëªº®æ¦¡¥L¤~±µ¨ü.........¡Ö¡@¡Õ

¥t¥~ªþ¤W¢Ó¢æ¢Ñ¢Ó¢Úªí¡ã¸ÌÀY¦³¨â­Ó­¶ÅÒ¡ã
¤@­Ó¬O§Ú­Ìªº®æ¦¡¡ã¤@­Ó¬O«È¤Hªí®æ...
·Q°Ý¬O§_¦³¿ìªk¤@¦¸±N³o8µ§¸ê®Æ¤@¦¸Âà¤J«È¤Hªºªí®æ¤¤©O¡H¡H¡H¡H
Àµ½Ð¦U¦ì¤j¯«À°¦£¡ã¡ã¡ã¡ã¡ã¡ã

1-1.JPG (118.19 KB)

1-1.JPG

2-2.JPG (165.18 KB)

2-2.JPG

3-3.JPG (118.97 KB)

3-3.JPG

4-4.jpg (185.01 KB)

4-4.jpg

TEST.zip (24.46 KB)

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-6-22 15:06 ½s¿è

¦^´_ 1# dodo234


    M9¶ñ¤J ¤§«á¤U©Ô¨ì©³
=IFERROR(VLOOKUP($B9, ¤u§@ªí1!A1:I20, MATCH(C6,¤u§@ªí1!A1:I1), FALSE),"")

TOP

¦^´_ 2# starry1314
·PÁÂstarry1314¤j
¦ý§Ú¶K¤W¥h«á¡ãµLªk¥X²{¼Æ­È»¡©O¡Ö¡@¡Õ
¤j¤j¥i§_±Ð¤@¤U©O¡H¡H¡H
¦]¬°³oÂà´«ªí§xÂZ§Ú¦n¤[³á¡ã¡ã¡ã¡ã
«ô°U¡ã¡ã¡ã¡ã

¥¼©R¦W.jpg (142.21 KB)

¥¼©R¦W.jpg

TOP

¦^´_ 3# dodo234


    «Øij¥ý±N¦X¨ÖÀx¦s¸Ñ°£«á¡A¦A±N¤½¦¡½Æ»s¨ìM9Àx¦s®æ¨Ã¤U©Ô¡A¦A¦X¨ÖÀx¦s®æ§Y¥i¡I

TOP

¦^´_ 3# dodo234

=IFERROR(VLOOKUP($B9, ¤u§@ªí1!$A$1:$I$20, MATCH($C$6,¤u§@ªí1!$A$1:$I$1), FALSE),"")

2015-06-22_232059.png (94.58 KB)

2015-06-22_232059.png

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-6-24 14:26 ½s¿è

¦^´_ 3# dodo234
¸Õ¸Õ
¨âºØ¤èªk
­×-TEST.rar (31.06 KB)
M32=VLOOKUP(B32,¤u§@ªí1!A1:I20,2,FALSE)

TOP

¦^´_ 6# starry1314
¯uªº«Ü·PÁÂstarry1314¤j¤jªº¨ó§U
§A¤§«eªº¤½¦¡¯à¥Î¤F¡ã¡ã¡ã
¥i¯à¬O¦]¬°§ÚªºEXCELªºª©¥»¤Ó¤F
§Ú¥Î2013¤½¦¡´N¥i¥H¥Î¤F¡ã¡ã¡ã¡ã
¯uªº¤Q¤À·P¿E±z
¤£¹L±z¦b¦¹½×¾Âªºªþ¥ó
§ÚªºLVÁÙ¤Ó¹à¡ã
¥Ø«eµLÅv­­¤U¸ü~~~>    <
¦ý±z³o¨â­Ó¤½¦¡§Ú³£¤w¸g¦¨¥\¥i¥H§ì¨ì¸ê®Æ¤F¡ã¡ã¡ã¡ã¡ã
¯uªº¸U¤À·PÁÂstarry1314¤j¡ã
³o´X¤Ñ¯uªº³Â·Ð±z¤F¡ã¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD