½Ð°ÝVLOOKUP¦³¿ìªk¥Î¬YÄæ¸Ì³¡¥÷¤@¼Ëªº¦r¤¸¥h¤ñ¹ï§ä¨ì¸ê®Æ¶Ü? ÁÂÁÂ!
- ©«¤l
- 59
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 0FFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2019-1-10
|
½Ð°ÝVLOOKUP¦³¿ìªk¥Î¬YÄæ¸Ì³¡¥÷¤@¼Ëªº¦r¤¸¥h¤ñ¹ï§ä¨ì¸ê®Æ¶Ü? ÁÂÁÂ!
VLOOKUP(A1,»ù!A:D,4,FALSE)
¦p¥Î¬YÄæA1="¼s¿n¬ì§ÞªÑ¥÷¦³¤½¥q"
¥h¤ñ¹ï§ä¨ì¥t¤@¤u§@ªíªºD¸ê®Æ,¦ý¥t¤@¤u§@ªíªºA¬O"¼s¿n",
½Ð°Ý¦³¿ìªk§ï¦¨A1¥u¦³³¡¥÷²Å¦X¤]§äªº¨ì¸ê®Æ¶Ü?
ÁÂÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¥Îªø¦r¦ê§äµu¦r¦ê¡AÀ³¸Ó¤£¦æ¡CÅܳqªº¿ìªk¬O¨úªø¦r¦ê«e±¤GÓ¦r¤¸¥h¤ñ¹ï¡C |
|
|
|
|
|
|
- ©«¤l
- 59
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 0FFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2019-1-10
|
¦^´_ 2# ANGELA
¦]¬°¦³¨Ç¤½¥q¦WºÙ¨Ã¤£¬O«e2¦r¬Û³q ©Ò¥H¨ú«e2Ó¦r¤¸¥h¤ñ¹ï¦³¨Ç¤½¥q·|µLªk§ä¨ì ¤£¹LÁÙ¬OÁÂÁ±z¤F! |
|
|
|
|
|
|
- ©«¤l
- 59
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 0FFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2019-1-10
|
³o¤]¥i¥H§ä¨ì~ ¯u¯«©_ ¯uªºÁÂÁÂHsiehª©¥D¼·ªÅ¸Ñµª! |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
|
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-9-17 08:24 ½s¿è
¤½¦¡¥i¥Hµu¤@点 :
=LOOKUP(,-FIND(Sheet2!A1:A4,A1),Sheet2!D1:D4) |
-
1
µû¤À¤H¼Æ
-
|
|
|
|
|
|
- ©«¤l
- 59
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 0FFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2019-1-10
|
¤]ÁÂÁ±zªº¸Ñµª~ ¥u¬O§Úµo²{¦ü¥G¤£¯à¥Î¾ã¦C(A:A)©Î©w°Ï°ì¤º(A1,A10)§äªº¤è¦¡,µ¥©ó»¡¶W¹L¤F(A1:A4)´N§ä¨ìªº¸ê®Æ·|ÅÜ0,³o¦b±`±`§ó·sªº¸ê®Æ¤W·|Åܪº«Ü³Â·Ð! |
|
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¤]ÁÂÁ±zªº¸Ñµª~ ¥u¬O§Úµo²{¦ü¥G¤£¯à¥Î¾ã¦C(A:A)©Î©w°Ï°ì¤º(A1,A10)§äªº¤è¦¡,µ¥©ó»¡¶W¹L¤F(A1:A4)´N§ä¨ìªº ...
eric866 µoªí©ó 2012-9-18 15:17
§ó§ï¬°
=LOOKUP(,-FIND(Sheet2!A1:INDEX(Sheet2!A:A,MATCH("*",Sheet2!A:A,-1)),A1),Sheet2!D1:INDEX(Sheet2!D:D,MATCH("*",Sheet2!D:D,-1))) |
|
|
|
|
|
|
- ©«¤l
- 59
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 0FFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2019-1-10
|
¦^´_ 9# JBY
«D±`ÁÂÁ±zªá®É¶¡À°§Ú¸Ñµª~´XÓ¦WºÙ¤j³£§äªº¥X¨Ó,¦ý§Ú¥t¥~¥Î¤j¶q¸ê®Æ¥h§ä¦ü¥G§ä¤£¥X¨Ó©Î¦³¿ù,§Ú¤]¤£ª¾¹D¬O§_§Ú¨º¸Ì¿ù¤F,¤£¹L¨SÃö«Y°Õ~¨ä¹ê§Ú¤w¸g©ñ±ó¥Î³oӤ覡¥h§ä¸ê®Æ¤F,¦]¬°¦³¨Çªø¦WºÙ¤¤¶¡Á٬ﴡ¨ä¥¦¦r,©Ò¥H«ç¼Ë¤]¤£¥i¯à§äªº¨ì¥L¤F,¤£¹LÁÙ¬OÁÂÁ±z¤F! excelÁöµM¦n¥Î,¦ý¤Ó½ÆÂø¤F,¾Ç²ß¦±½unªá«Üªø! |
|
|
|
|
|
|