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

[µo°Ý] Vlookup«ç°µ½Æ¦XÀ³¥Î

[µo°Ý] Vlookup«ç°µ½Æ¦XÀ³¥Î

½Ð°Ý

Vlookup¯à°µ2µ§¥H¤W¬Û¦P¦WºÙ¤§´M§ä­È¡A°µ¥X¹ïÀ³ªº¸ê®Æ¶Ü?

¥Hªþ¥óªº
¤u§@ªí"DATA"¬°¸ê®Æ®w
¤u§@ªí"´M§ä­È"¬°¿é¤J·Q´M§äªº­È«á¡A±a¥X¸ê®Æ

ÁÙ±æ¦U¦ì¥ý¶i¨ü±Ð¡C

ÁÂÁÂ

´M§ä­È.zip (2.15 KB)

a

§Ú¥ÎINDEX¥i²Å¦X»Ý¨D(¨ú¥N¬d¸ß2­Ó±ø¥óªºVLOOKUP)¡A¦ý¤]Åýªí®æÅܱo«ÜºC¡C
½Ð°Ý¡A·ÓµÛHsieh¤jªº¨BÆJ...
°Ñ¼Æ­Èªº¨Ó·½¤@¦¸¥u¯à¬d¤@µ§¶Ü? ­Y¬OA2¬dªºµ²ªGÅã¥Ü©óB2.C2¡AA3¬dªºµ²ªGÅã¥Ü©óB3.C3¡A¬O§_´N¤£¾A¦X¥Î¦¹¤èªk¤F?©ÎÀ³¦p¦ó§ï©O¡AÁÂÁ¡C

TOP

gif¬Ý¤£¨ì¤ÓÀ´³]©w¹Lµ{~~~¥i¬O¬Ý°_¨Ó¹³¬O EXL+ACCESS¤@°_°µ¥X¨Óªº¶Ü?
¥ÎACCESS°µ¸ê®Æ®w¡AµM«á¥ÎEXCEL°µ¬d¸ßªí³æªº·N«ä¶Ü?

ACCESS¤£¬O³£­n¥ÎACCESS¦Û¤v°µ"¬d¸ßªí³æ"¨Ó¥Î?
¥i¥H¥ÎEXCEL°µªí³æ¡A¥h¬dACCESSªº¸ê®Æ¶Ü??

TOP

¦^´_ 9# keny1021


   
¥¼©R¦W.png
2013-1-28 20:12
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh



Hsieh¤j¦A³Â·Ð«üÂI:'(

¤p§Ì«ö·ÓµÛgifªº¨BÆJ...
·í§Ú¶×¤J¥~³¡¸ê®Æ®É¡A¿ï¨úexcel files*¡A«o¥X²{
"¦¹¸ê®Æ¨Ó·½¨Ã¥¼¦s¦b¥i¨Ï¥Îªºªí®æ"

TOP

¦^´_ 7# keny1021


   ¤j¶q¸ê®Æ­ì¥»´N¤£¾A¦X¨Ï¥Î°}¦C¤½¦¡
¥Î¸ê®Æ¬d¸ß©Î¶i¶¥¿z¿ï¤~¬O¥¿³~
play.gif
2013-1-28 16:26
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ·PÁÂHsieh ¤j¡A
      ¦A½Ð±Ð¦pªG¸ê®Æ¦³2¸U¦hµ§¡A¬O§_¤£¾A¥Î°}¦C¤½¦¡¶]?
    ¦]¬°·|¤@ª½­«ºâÀx¦s®æ¡C

TOP

¦^´_ 5# keny1021

B2°}¦C¤½¦¡
=INDIRECT("DATA!R"&SMALL(IF(DATA!$A$2:$A$13=´M§ä­È!$A$2,ROW($2:$13),""),ROW(A1))&"C",0)
¦V¤U¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# JBY

·PÁÂ2¦ì«e½ú¨ü±Ð

¦ý«çBÄ榳¿ìªk±a¥Xµ²ªG¶Ü?
A2¬°´M§ä­È±a¤J"³³©É«C"
B2=¨­°ª
B3=Åé­«
B4=µø¤O
----------------------------
C2=155
C3=42
C4=1.3
CÄæ®M¥Î«e½úªº¤½¦¡µ²ªGOK

TOP

¦^´_  keny1021
´£¨Ñ¤U¦C¤èªk¡A½Ð°Ñ¦Ò¡I
Step_1¡G©ó¡u´M§ä­È¡v¤u§@ªí¤§C2Àx¦s®æ¿é¤J
=INDEX(DATA!$CC ...
p212 µoªí©ó 2013-1-25 14:16


¦pªG Office ª©¥»¬O 2007©Î¥H¤W

¤½¦¡¤£­n ¥Î¾ãÄæ¦]¬°

Office ª©¥» 2007©Î¥H¤W, §@ªí³Ì¤j¦æ数¬° : 1.1¦Ê¸U¦C

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD