ªð¦^¦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

¦^´_ 1# keny1021
´£¨Ñ¤U¦C¤èªk¡A½Ð°Ñ¦Ò¡I
Step_1¡G©ó¡u´M§ä­È¡v¤u§@ªí¤§C2Àx¦s®æ¿é¤J
=INDEX(DATA!$C:$C,MATCH(´M§ä­È!$A$2&B2,DATA!A:A&DATA!B:B,0))
Step_2¡GÄò¥HCtrl+Shift+Enter§¹¦¨²Õ¦X¤½¦¡(°}¦Cªk)
Step_3¡G¦V¤U½Æ»s¤½¦¡§Y¥i

TOP

给2个´¶³q¤½¦¡ :

1. =INDEX(DATA!C$1:C$100,INDEX(MATCH(´M§ä­È!$A$2&B2,DATA!A$1:A$100&DATA!B$1:B$100,0),))


2. =SUMPRODUCT((DATA!A$2:A$100=´M§ä­È!A$2)*(DATA!B$2:B$100=´M§ä­È!B2),DATA!C$2:C$100)


¤½¦¡¦V¤U½Æ»s

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

¦^´_ 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

¦^´_ 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

¦^´_ 6# Hsieh


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

TOP

¦^´_ 7# keny1021


   ¤j¶q¸ê®Æ­ì¥»´N¤£¾A¦X¨Ï¥Î°}¦C¤½¦¡
¥Î¸ê®Æ¬d¸ß©Î¶i¶¥¿z¿ï¤~¬O¥¿³~
play.gif
¾Ç®üµ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

¦^´_ 9# keny1021


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD