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

½Ð°Ý­n¦p¦ó³]©w¦¨¡u¦bsheet2ªºB1¿é¤J½s¸¹«á¡AB2¤ÎB3¦Û°Ê¸õ¥X§Ú¦bsheet1ªº¸ê®Æ¡v?

½Ð°Ý­n¦p¦ó³]©w¦¨¡u¦bsheet2ªºB1¿é¤J½s¸¹«á¡AB2¤ÎB3¦Û°Ê¸õ¥X§Ú¦bsheet1ªº¸ê®Æ¡v?

¦U¦ì¥ý¶i¤j¤j­Ì±z­Ì¦n¡A·Q½Ð°Ý¦p¼ÐÃD©Ò­zºÃ°Ý­n¦p¦ó³]©w?
¤ñ¦p»¡sheet1§Ú©Ò³]©wªº¸ê®Æ¬O³o¼Ë
½s ¸¹    «~          ¦W    ³æ¦ì
a001    ­ì¤lµ§-¬õ      °¦
a002    ­ì¤lµ§-ÂÅ      °¦
b001    ¾ó¥ÖÀ¿           ¥u
b002    ­×¥¿±a           ¥u
c001    °v®Ñ¾÷           ¥u
c002    °v®Ñ°w           ²°
§Ú·Q­n¦bsheet2ªºB1Äæ¦ì¤¤¿é¤Jª««~½s¸¹¡A¥kÃäÄæ¦ìB2¤ÎB3¦Û°Ê¸õ¥X§Ú¦bsheet1ªº¸ê®Æ
¤]´N¬O»¡§Ú¦bÄæ¦ìB1¿é¤J"b001"¡AB2¦Û°Ê¸õ¥X"¾ó¥ÖÀ¿"¡AB3¦Û°Ê¸õ¥X"¥u"

§Ú¦³¥ý¬d¾\¤§«eªº¤å³¹¡A¤µ¤Ñ¤w¸g¾Ç·|¤G¼h¦¡¤U©Ô¿ï³æ:D
¯uªº«Ü°ª¿³¦b³o½×¾Â¥i¥H¾Ç¨ì¦n¥Îªºª¾ÃÑ¡A¥i¥H¤j´TÁY´î¿é¤J¸ê®Æ¿ù»~¥i¯à©Ê¥H¤Î´î¤Ö­«½Æ©Ê¿é¤J¸ê®Æªº°ÝÃD
¤H¥Í´N¬O¤£Â_ªº¾Ç²ß¦A¾Ç²ß

«e¨¥¡G¦L¶H¤¤ ½×¾Â¤º¦³Ãþ¦ü¥Îªk¡A¤£ª¾¹D¬O§_¦³·j´M¡Bª¦¤å???

¨BÆJ
1.­Ysheet1 ¤w¦³¸ê®Æ¡A±NA:CÄæ¦ì°é¿ï°_¨Ó«á¡A¤½¦¡ > ©w¸q¦WºÙ ¡A¦AÂI¿ï ±q¿ï¨ú¤¤«Ø¥ß
2.­Ysheet2 ¤w¦³±ý·j´M¼ÐÃD¡A¦b B2(ªÅ¥Õ) ¿ï¾Ü¤W¦C¤u¨ã¦Cªº ¸ê®ÆÅçÃÒ >¤¹³\(²M³æ) >¨Ó·½¥´ (=«~¦W)
3.¦bC2 ¤º¿é¤J  =INDEX(INDIRECT(C1),MATCH($B$2,INDIRECT($B$1),0)) ¡A¨Ã¥B½Æ»s¶K¤W¦bA2

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# cgl

¤£¾å±o³o¬O¤£¬O±z·Q°Ýªºµª®×
¦bB2¿é¤J¡u=VLOOKUP(A2,Sheet1!A:C,2,0)¡v
¦bB3¿é¤J¡u=VLOOKUP(A2,Sheet1!A:C,3,0)¡v

   
   

TOP

¦^´_ 2# mark15jill
ÁÂÁ±z¡A§Ú¬O¦³ª¦¤å¹L¤~PO¤åªº¡A¤]¦]¬°³o¼Ë¤~¾Ç·|¦h¼h¦¡¤U©Ô¿ï³æ ^^
¥u¬O¡A¥i¯à¦b·j´Mªº¹Lµ{¤¤
¤]³\¼ÐÃD©Î¬O¸ß°Ý¤è¦¡©Ò¤£¦P
Åý¤p§Ì¤£ª¾¨ì¬O§_´N¬O§Ú©Ò­n°Ýªº°ÝÃD
¤£¹L~~ÁÙ¬OÁÂÁ±z
¤H¥Í´N¬O¤£Â_ªº¾Ç²ß¦A¾Ç²ß

TOP

¦^´_ 3# emma
¤Ó·PÁ±z¤F¡A­É§U±zªº«ü¾É§Ú¤w¸g§¹¦¨§Úªº¤u§@ÀɮפF
¦A¦¸ÁÂÁ±z
±µ¤U¨Ó§Ú­n¥h§ä¡A¦p¦óÅý#N/A®ø¥¢¤£¨£Åo
¤H¥Í´N¬O¤£Â_ªº¾Ç²ß¦A¾Ç²ß

TOP

¦^´_ 5# cgl

YA~~¹B®ð¯u¦n¡A¤µ¤Ñ¤S¾Ç²ß¨ì³o©Û§â¿ù»~°T®§ÁôÂÃ
=IF(ISERROR(VLOOKUP(Äæ¦ì,code,2,0)),"",VLOOKUP(Äæ¦ì,code,2,0))
¤H¥Í´N¬O¤£Â_ªº¾Ç²ß¦A¾Ç²ß

TOP

¦^´_ 6# cgl


    2007ª©ªºexcel¥i¥Î=IFEROR(VLOOKUP(Äæ¦ì,code,2,0),"")

TOP

¦^´_ 7# ANGELA

ÁÂÁ±zªº¦^ÂÐ ^^
­ì¨Ó¦P¼Ëªº¥\¯à¡A¥i¥H¦³³o»ò¦hºØ¤£¦Pªº¤è¦¡¨Ó§i¶D¹q¸£!!
¬Ý¨ÓÁÙ¦³¦n¦h¦n¦h­n¾Ç¡A¦A¦¸ÁÂÁ¦U¦ì :loveliness:
¤H¥Í´N¬O¤£Â_ªº¾Ç²ß¦A¾Ç²ß

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD