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

¦p¦ó¦Û°Ê±a¤J2

¦p¦ó¦Û°Ê±a¤J2

¤§«e¦³µo°Ý¹LÃþ¦üªº°ÝÃD¡A¥i¬O²{¦b²{¦b¦³©Ò§ïÅÜ¡A´N¬O§Ú¦b¤u§@ªí¸Ì¦³A1³æ¦ìB1¤H¦WC1²Î½sµ¥¸ê®Æ¡AµM«á§Ú·Q¦bF1¿é¤J¤H¦W¡AE1´N·|¦Û°Ê±a¥X³æ¦ì¡AG1±a¥X²Î½s¡A§Ú¦bE1¥Î=VLOOKUP($F1,$A$2:$C$6,2)¡A¦ýµ²ªG¦bF1¿é¤H¦W´NÅܦ¨#N/A¡F¦bG1¿é¤J=VLOOKUP($E2,$B:$C,2,FALSE)¡AF1¿é¤J¤H¦W«á¡AG1´N¥¿½T¶]¥X¬Û¹ïÀ³²Î½s¡A½Ð°Ý¦U¦ì¤j¤jE1­n¿é¤J¦ó¨ç¼Æ¤~¥¿½T¡C
image002.jpg
2011-6-15 21:53

VLOOKUPªº·j´M­È¥²¶·¦bªí®æ³Ì¥ª¤@Äæ
¤]´N¬O³æ¦ì­n¦bBÄæ¡A©m¦W¦bAÄæ
¦pªG¤£§ó§ïªí®æ´N¥²¶·¨Ï¥ÎMATCH§ä¥X©m¦Wªº¦C¦ì
µM«á¥ÎINDEX¦bAÄæ¤W¹ïÀ³
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh¶W¯Åª©¥D±z¦n¡G
§Úªºªí®æ¨S¦³­n§ó§ï¡A©Ò¥H¯à¤£¯à½Ð§A¦n¤H°µ¨ì©³¡A³o2­Ó¨ç¼Æ­n«ç»ò¹B¥Î¡A¦]¬°¹ï¨ç¼Æ¤£¬O«Ü¤F¸Ñ¡AÁÂÅo!

TOP

Hsieh¶W¯Åª©¥D±z¦n¡G
·PÁ±z¤§«e¨º½s¡y¦p¦ó¹ïÀ³¸ê®Æ?¡z¡A§Ú§ä¨ì¸Ñµª¤F¡A«D±`ªºÁÂÁ±z¡C

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2011-6-15 22:55 ½s¿è

¤£ª¾³o¬O¤£¬O§A­nªºµ²ªG
E1=INDEX(A:C,MATCH($F$1,B:B,0),1)
G1=INDEX(A:C,MATCH($F$1,B:B,0),3)

TOP

VVCVC±z¦n¡G
§Ú¦bE1¬O¼g=INDEX(A$2:A$6,MATCH($F1,$B$2B$6,0),)¦ÓG1¬O=VLOOKUP($F1,$BC,2,FALSE)¡A³o¼Ë¸ê®Æ¥u­n¿é¤J¦W¦r´N¦Û°Ê±a¤J³æ¦ì©M²Î½s¤F¡A¥u¬OÁÙ¨S¿é¤J¦W¦r¸ê®Æ®É¡A³æ¦ì©M²Î½s´N¶]¥X#N/A¡A¯à¤£¯àÁÙ¨S¿é¤J¦W¦r®É³æ¦ì©M²Î½s¬OªÅ¥Õ¦Ó¤£­n¦³#N/Aªº¦r¶]¥X¨Ó¡C

TOP

¥[­Óif
=IF(F1="","",INDEX(A:C,MATCH($F$1,B:B,0),1)

TOP

VVCVC±z¦n¡G
·PÁ±zªº¤èªk¡AÁÂÁ¡A°ÝÃD¤w¸Ñ¨M¡C

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD