vlookup ¤½¦¡¤U©Ô«á¦³ªº·|§ì¨ì¡A¦³ªº·|¥X²{#n/a
- ©«¤l
- 28
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-13
- ³Ì«áµn¿ý
- 2014-4-18
|
vlookup ¤½¦¡¤U©Ô«á¦³ªº·|§ì¨ì¡A¦³ªº·|¥X²{#n/a
§Ú¦³¤u§@ªí1©M¤u§@ªí2¡A¦b¤u§@ªí1¬O¥X³f³æ¡Aªí2¬O¦X¬ù¼Ð³æ
¥X³f³æªº¶µ¥Ø¦WºÙ¦³³]©w¤U©Ô¿ï³æ¡A¥un¿ï¨ú¤U©Ô¿ï³æ¡A³æ¦ì¤Î¦X¬ù¼Æ¶q§Y¥i¦Û°Ê¥X²{
¦ý¥Ø«e¦³Ó°ÝÃD¬O§Ú¼g§¹¤½¦¡«á¡A¦³ªº·|¥X²{¥¿½Tªºµ²ªG¡A¦³ªº«h·|¥X²{#N/A
§Ú¼gªº¤½¦¡¦p¤U
=IF(E9="","",VLOOKUP(E9,¦X¬ù!$B$3:$D$2470,2,0))
¬d¤å»¡¦³¥i¯à¬OÀx¦s®æªº®æ¦¡¡A©Ò¥H®æ¦¡¥þ§ï¬°³q¥Î®æ¦¡
¥X²{#N/Aªº¦a¤èÁÙ¬O#N/A
·Q½Ð°ÝÁÙ¦³¤°»òì¦]·|³y¦¨³¡¥÷¥iŪ¨ú¡A³¡¥÷µLªkŪ¨ú¡C |
|
|
|
|
|
|
- ©«¤l
- 28
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-13
- ³Ì«áµn¿ý
- 2014-4-18
|
¦^´_ 13# ML089
¦n¡AÁÂÁ§A!! |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 12# §±æ¢
§An«ö¦U·N¨£¤U¤èªº¦^ÂСA¨t²Î¤~·|³qª¾¸Ó¤Hû¡A¤£µM§Aªº·N¨£®e©ö³Q©¿²¤¹L¥h¡C
¦³ªÅ¦h¨Ó¥»°ÏÆ[¼¯§O¤Hªº¤½¦¡¡A«Ü§Ö´N¯à¶i¨B |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 28
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-13
- ³Ì«áµn¿ý
- 2014-4-18
|
ÁÂÁÂ!!
§ÚÁ`ı±o¨ç¼Æ¦nÃø¡A¥i¬O¶W¦n¥Îªº¡A³o¦¸¯uªºn»{¯uªº¾Ç¤F |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# §±æ¢
* ~ ¬°VLOOKUP¡BMATCH ..µ¥ªº¯S®í²Å¸¹¡A³y¦¨¬d¸ß¿ù»~
¥H¤U¨ç¼Æ¨Ï¥Î®É¤ä´©¸U¥Î¦r¤¸¡A¬d¸ß¤å¦r¤¤¦³ ? * ~ µ¥²Å¸¹nª`·N¨Ï¥Î
COUNTIF
HLOOKUP
MATCH
SEARCH
SUMIF
VLOOKUP
¸U¥Î¦r¤¸¥i°Ñ¦Ò
http://office.microsoft.com/zh-tw/excel-help/HP005203612.aspx
¥X³f³æ!E9 = "ÂI¥ú (3F~35FªF«n¦V.¦è¥_¦V¶§¥x¤W¤è®æ¬])"
¦]¦r¦ê¤º¦³ ~ ¦r¤¸·|³y¦¨¬d¸ß¿ù»~
J9
줽¦¡ =IF(E9="","",VLOOKUP(E9,¦X¬ù!$B:$D,3,))
§ï¬° =IF(E9="","",VLOOKUP(SUBSTITUTE(E9,"~","~~"),¦X¬ù!$B:$D,3,))
©Î§ï¬° =IF(E9="","",LOOKUP(,0/(E9=¦X¬ù!$B:$B),¦X¬ù!$D:$D))
¥X³f³æ!E14 = "EMT¾É½uºÞ 1_1/2" (E51)"
¦X¬ù!B1070 = "EMT¾É½uºÞ 1-1/2" (E51)"
½Ð±N _ §ï¬° - ´N¹ï¤F
E15 : "Web ºô¸ô³q°T¦øªA¥D¾÷ 573992 Ehternet Gateway TCP.IP_SCS"
°ÝÃD¦P¤W |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 49
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2014-2-13
- ³Ì«áµn¿ý
- 2020-9-18
|
¥»©«³Ì«á¥Ñ huijuang ©ó 2014-3-27 10:13 ½s¿è
¨Ï¥ÎsumifÀ³¸Ó¤£¥ÎISERROR
§Ú°µªº®ÉÔ¬Oª½±µ®³§A¤§«eªº¤½¦¡¨Ó§ï
©Ò¥H§Ñ¤F§âISERROR®³±¼¤F
=IF(E9="","",SUMIF(¥X³f²M³æ!$E$2:$E$2000,¥X³f³æ!E9,¥X³f²M³æ!$F$2:$F$2000)+F9) |
|
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang
|
|
|
|
|
- ©«¤l
- 28
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-13
- ³Ì«áµn¿ý
- 2014-4-18
|
¨Ï¥Î =IF(ISERROR(SUMIF(¥X³f²M³æ!E2:E2000,¥X³f³æ!E9,¥X³f²M³æ!F2:F2000)),"0",SUMIF(¥X³f²M³æ!E2:E2000,¥X³f³æ!E9,¥X³f²M³æ!F2:F2000))+F9
¥[Á`ªº¼Æ¶q´N¥¿½T¤F¡AÁÂÁ©O!!
§Ú쥻·Qn¥Î=IF(E9="","",SUMIF(¥X³f²M³æ!$E$3:$E$1048576,E9,¥X³f²M³æ!$F$3:$F$1048576)+F9)¡A·Q½Ð°Ý¥[¤WISERRORªº®t§O¦bþ?? |
|
|
|
|
|
|
- ©«¤l
- 49
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2014-2-13
- ³Ì«áµn¿ý
- 2020-9-18
|
¦^´_ 5# §±æ¢
¤£ª¾¹D²Ä¤Tµ§ÅÜ´î¡ö¬O¦ó·N
¤£¹L¦pªG²Îpªº¸Ü
¥i¥H¥Î¤U¦Cªº¤½¦¡¬Ý¬Ý¦æ¤£¦æ
=IF(ISERROR(SUMIF(¥X³f²M³æ!E2:E2000,¥X³f³æ!E9,¥X³f²M³æ!F2:F2000)),"0",SUMIF(¥X³f²M³æ!E2:E2000,¥X³f³æ!E9,¥X³f²M³æ!F2:F2000))+F9 |
|
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang
|
|
|
|
|
- ©«¤l
- 28
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-3-13
- ³Ì«áµn¿ý
- 2014-4-18
|
°ÝÃD¦b¡u³]³Æ³]©w¡v¸ÌÀY
§Ú±N¡u³]³Æ³]©w¡v«·s¾ã²z¡Aª½±µ±q¦X¬ù¡v¤¤½Æ»s¹L¥h¡A°ÝÃD¤w¸Ñ¨M¡A¦³¥i¯à¬O·íªì¾ã²zªº¤p©f¾Þ§@¤W¦³»~¡A©ÎªÌ¦³¦P¨Æ°Ê¹L§a¡A«D±`·PÁ¤G¦ì¦Ê¦£¤§¤¤¯àÀ°§Ú
§Ú¨M©w¥Î¦nªº¸ê®Æ¤WÂê¤F¡C
§Úªº²Ä¤GÓ°ÝÃD¤]Åý§Ú«ÜÀYµh¡A²Ä¤@µ§¥[¤W²Ä¤Gµ§µ²ªG¬O¥¿½Tªº¡A¦A¥[¤W²Ä¤Tµ§´NÅܦ¨´î¤F¡K
¬O¤£¬On¥[¤WSUM??©ÎªÌ§Ú¤£¸Ó¦b«á±¥[¤W+F9 ?? |
|
|
|
|
|
|