Excelã¯åºæ¬çã«ã¯ã·ã³ãã«ãªè¡šèšç®ãœããã§ãããé¢æ°ã䜿ãããªãããã€ãè€æ°ã®é¢æ°ãæãåãããŠäœ¿çšãããããšã§ã顧客ãªã¹ãããããŠã§ããµã€ãã®PVæ°ããªã©è€éãªããŒã¿ãå¹ççã«åŠçã§ããããã«ãªããŸãã
ä»åã¯ãŸãèŠããã¹ãExcelã®ãã䜿ãé¢æ°ã18åãå®çšäŸãšã»ããã§è§£èª¬ããŸãããªãã»ããã§èŠããŠããããã·ã§ãŒãã«ããäžèŠ§ã¯ãã¡ãã®èšäºãåèã«ããŠãã ããã
ãæ°å€ãæ±ããã®ãExcelã®ãã䜿ãé¢æ°äžèŠ§
Excelã§ã¯ããã人åãšé£çµ¡å ã®ãªã¹ããããåºèãªã¹ããããŸãããŠã§ããµã€ãã®ããŒãžããšã®PVæ°ããªã©èšå€§ãªããŒã¿ãæ±ãããšããããŸããããããããã®ããŒã¿ã¯å¿ ãããæ±ãããã圢åŒã§ç®¡çãããŠããããã§ã¯ãããŸããããã£ãŠãæ°å€ãããæååããæ±ãããã圢ã«æ圢ãããããåèšå€ããå¹³åå€ããªã©ãæ±ãããããã®ããŒã¿ããå¿ èŠãªéšåã ããæãåºãããšãå¿ èŠãªããšãã
ãŸãã¯æ°å€ãæ±ãé¢æ°ã玹ä»ããŸãã
SUM: éžæããç¯å²ã®åèšå€ãèšç®ãã
SUMé¢æ°ã¯ãéžæããç¯å²ã®åèšå€ãèšç®ããããã®é¢æ°ã§ãã
![SUM: éžæããç¯å²ã®åèšå€ãèšç®ãã1](https://img2.bakusai.com/p/img/rss_news/11077180/2_original.jpg)
ããšãã°ãA1ããA5ãŸã§ã®ç¯å²ã®åèšå€ãèšç®ãããå Žåã次ã®ããã«SUMé¢æ°ã䜿çšããŸãã=SUM(A1:A5)
è€æ°ã®ç¯å²ãéžæããŠåèšå€ãèšç®ããããšãå¯èœã§ãã
![SUM: éžæããç¯å²ã®åèšå€ãèšç®ãã2](https://img2.bakusai.com/p/img/rss_news/11077180/3_original.jpg)
A1ããA5ãšB1ããB5ãŸã§ã®ç¯å²ã®åèšå€ãèšç®ãããå Žåã次ã®ããã«SUMé¢æ°ã䜿çšããŸãã=SUM(A1:A5,B1:B5)
AåããAæ ¡ã®æããšã®å£²äžããBåããBæ ¡ã®æããšã®å£²äžãã ãšããå Žåãç¯å²ãããŸãå€ããããšã§ãAæ ¡ã®ã¿ã®å£²äžãããAæ ¡ãšBæ ¡ã®åèšããåºããŸãã
AVERAGE: éžæããç¯å²ã®å¹³åå€ãèšç®ãã
AVERAGEé¢æ°ã¯ãéžæããç¯å²ã®å¹³åå€ãèšç®ããããã®é¢æ°ã§ãã
![AVERAGE: éžæããç¯å²ã®å¹³åå€ãèšç®ãã1](https://img2.bakusai.com/p/img/rss_news/11077180/4_original.jpg)
ããšãã°ãA1ããA5ãŸã§ã®ç¯å²ã®å¹³åå€ãèšç®ãããå Žåã次ã®ããã«AVERAGEé¢æ°ã䜿çšããŸããæã®å¹³å売ãäžããªã©ãåºãã®ã«ã¡ããã©ããã§ãã=AVERAGE(A1:A5)
ãªãSUMé¢æ°ãšåæ§ã«ãè€æ°ç¯å²ãæå®ããããšãå¯èœã
![AVERAGE: éžæããç¯å²ã®å¹³åå€ãèšç®ãã2](https://img2.bakusai.com/p/img/rss_news/11077180/5_original.jpg)
è€æ°ç¯å²ãæå®ããå Žåã¯ã=AVERAGE(A1:A5,B1:B5)ãã®ããã«æžããŸãã Aæ ¡ãšBæ ¡ã®æããšã®å¹³å売ãäžããåºããŸã
MAX: éžæããç¯å²ã®æ倧å€ãæ±ãã
MAXé¢æ°ã¯ãéžæããç¯å²ã®æ倧å€ãæ±ããããã®é¢æ°ã§ããé¢æ°ã®æžãæ¹ãã®ãã®ã¯ãSUMãããAVERAGEããšå€§ããå€ãããŸãããããšãã°ãA1ããA5ãŸã§ã®ç¯å²ã®æ倧å€ãæ±ãããå Žåã次ã®ããã«MAXé¢æ°ã䜿çšããŸãã
=MAX(A1:A5)
MIN: éžæããç¯å²ã®æå°å€ãæ±ãã
MAXé¢æ°ã¯ãéžæããç¯å²ã®æå°å€ãæ±ããããã®é¢æ°ã§ããA1ããA5ã®æå°å€ãæ±ããå Žåã¯ã以äžã®ããã«äœ¿çšããŸãã
=MIN(A1:A5)
ãæååæäœãã§ãããã®ãExcelã®ãã䜿ãé¢æ°äžèŠ§
ç¶ããŠæååæäœãã§ããé¢æ°ã玹ä»ããŸããããšãã°ãç¥å¥å·çãã暪æµåžããšåãããŠãã2ã€ã®èªå¥ããç¥å¥å·ç暪æµåžããšæ圢ãããããç¥å¥å·ç暪æµåžãããã暪æµãã ããæœåºãããšãã£ãããšãå¯èœã§ãã
CONCATENATE: ã»ã«å ã®è€æ°ã®æååãçµåãã
CONCATENATEé¢æ°ã¯ãã»ã«å ã®è€æ°ã®æååãçµåããããã®é¢æ°ã§ãã
![CONCATENATE: ã»ã«å
ã®è€æ°ã®æååãçµåãã1](https://img2.bakusai.com/p/img/rss_news/11077180/6_original.jpg)
ããšãã°ãA1ã«ããªããããšããæååããããB1ã«ãã©ã€ãããšããæååãããå Žåã次ã®ããã«CONCATENATEé¢æ°ã䜿çšããŠãA1ãšB1ã®æååãçµåã§ããŸãã=CONCATENATE(A1,B1)
ãŸããCONCATENATEé¢æ°ãã=A1&B1ããšæžãããšãã§ããŸããã©ã¡ãã§ãåŸãããåºåçµæã¯åãã§ããã¡ãªã¿ã«çè ã¯ãããhttps://ããšãotona-life.comããçµåãããéã«ããã®é¢æ°ã䜿ããŸããããã¡ã€ã³ããèšèŒãããŠããªãè³æããšããã®ã¯ãããããã®ã§ãã
LEFT: ã»ã«å ã®æååã®å·Šç«¯ããæå®ããæåæ°ãååŸãã
LEFTé¢æ°ã¯ãã»ã«å ã®æååã®å·Šç«¯ããæå®ããæåæ°ãååŸããããã®é¢æ°ã§ãã
![LEFT: ã»ã«å
ã®æååã®å·Šç«¯ããæå®ããæåæ°ãååŸãã1](https://img2.bakusai.com/p/img/rss_news/11077180/7_original.jpg)
ããšãã°ãA1ã«ãç¥å¥å·ç暪æµåžããšããæååããããå·Šãã4æåã ããååŸãããå Žåã次ã®ããã«LEFTé¢æ°ã䜿çšããŸãã=LEFT(A1,4)
ãã®åŒãå ¥åãããšããç¥å¥å·çããšããæååã衚瀺ãããŸããã暪æµåžãã®æ å ±ãäžèŠãªæã«ãããŒã¿ãæ圢ããã®ã«åœ¹ç«ã€ããšããããŸãã
RIGHT: ã»ã«å ã®æååã®å³ç«¯ããæå®ããæåæ°ãååŸãã
RIGHTé¢æ°ã¯ãLEFTé¢æ°ã®éã§ãå³ç«¯ãããæåæ°ã®ååŸãè¡ããŸãããç¥å¥å·ç暪æµåžããšæžãããA1ã»ã«ã«å¯ŸããŠãã=RIGHT(A1,3)ããšæžããšã暪æµåžãã ããæœåºã§ããŸãã
LEN: ã»ã«å ã®æååã®é·ããååŸãã
LENé¢æ°ã¯ãã»ã«å ã®æååã®é·ããååŸããããã®é¢æ°ã§ãã
![LEN: ã»ã«å
ã®æååã®é·ããååŸãã1](https://img2.bakusai.com/p/img/rss_news/11077180/8_original.jpg)
ããšãã°ãA1ã«ãappleããšããæååãããå Žåã次ã®ããã«LENé¢æ°ã䜿çšããŠãA1ã®æååã®é·ããååŸã§ããŸãã=LEN(A1)
ãè«çã«é¢ãããã®ãExcelã®ãã䜿ãé¢æ°äžèŠ§
ãããŸã§ã«çŽ¹ä»ããé¢æ°ã䜿ã£ãŠãæååãæ°å€ãæ±ãããã圢ã«æŽããããIFé¢æ°ããANDé¢æ°ããªã©ã䜿ã£ãè€éãªåŠçãããŠã¿ãŸãããã4ã€ã®ãè«çãã«é¢ããé¢æ°ã玹ä»ããŸãã
IF: æ¡ä»¶ã«å¿ããŠå€ãè¿ãïŒçãªãããåœãªãÃãªã©ïŒ
IFé¢æ°ã¯ãæ¡ä»¶ã«å¿ããŠå€ãè¿ãããã®é¢æ°ã§ãäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=IF(æ¡ä»¶åŒ, çã®éã®å€, åœã®éã®å€)
äŸ1ïŒA1ã«ããæ°å€ã50ãã倧ããå Žåã«ã倧ããããšè¡šç€ºããããã§ãªãå Žåã¯ãå°ããããšè¡šç€ºãã
![IF: æ¡ä»¶ã«å¿ããŠå€ãè¿ãïŒçãªãããåœãªãÃãªã©ïŒ1](https://img2.bakusai.com/p/img/rss_news/11077180/9_original.jpg)
=IF(A1>50, “倧ãã”, “å°ãã”)
äŸ2ïŒA1ã«ããæ°å€ãA2ã«ããæ°å€ãã倧ããå Žåã«ãYesããšè¡šç€ºããããã§ãªãå Žåã¯ãNoããšè¡šç€ºãã
![IF: æ¡ä»¶ã«å¿ããŠå€ãè¿ãïŒçãªãããåœãªãÃãªã©ïŒ2](https://img2.bakusai.com/p/img/rss_news/11077180/10_original.jpg)
=IF(A1>A2, “Yes”, “No”)
ãªããIFé¢æ°ã®äºçš®ã®1ã€ããIFERRORãé¢æ°ãIFERRORé¢æ°ã䜿ããšãããšãã°æå®ãããã»ã«ããšã©ãŒã®å Žåã«ãnot foundããè¿ããšãã£ãé¢æ°ãæžãããšãã§ããŸããVLOOKUPé¢æ°ãšçµã¿åããããšéåžžã«äŸ¿å©ãªãããåŸåã§çšäŸã解説ããŸãã
AND: è€æ°ã®æ¡ä»¶ããã¹ãŠæºããããŠããå Žåã«çãè¿ã
ANDé¢æ°ã¯ãè€æ°ã®æ¡ä»¶ããã¹ãŠæºããããŠããå Žåã«TRUEïŒçïŒãè¿ãé¢æ°ã§ããäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=AND(æ¡ä»¶1, æ¡ä»¶2, …)
äŸïŒA1ã«ããæ°å€ã5以äžã§ããããã€A2ã«ããæ°å€ã7以äžã®å Žåã«TRUEãè¿ã
![AND: è€æ°ã®æ¡ä»¶ãå
šãŠæºããããŠããå Žåã«çãè¿ã1](https://img2.bakusai.com/p/img/rss_news/11077180/11_original.jpg)
=AND(A1>=5, A2<=7)
OR: è€æ°ã®æ¡ä»¶ã®ãããããæºããããŠããå Žåã«çãè¿ã
ORé¢æ°ã¯ãè€æ°æ¡ä»¶ã®ãããããããæºããããŠããå ŽåãTRUEïŒçïŒãè¿ãé¢æ°ãäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=OR(æ¡ä»¶1, æ¡ä»¶2, …)
äŸïŒ1ãšA2ã«ããæ°å€ããšãã«10ãã倧ããå Žåããããã¯A3ã«ããæ°å€ã20ãã倧ããå Žåã«TRUEïŒçïŒãè¿ããããã§ãªãå Žåã«ã¯FALSEïŒåœïŒãè¿ã
![OR: è€æ°ã®æ¡ä»¶ã®ãããããæºããããŠããå Žåã«çãè¿ã1](https://img2.bakusai.com/p/img/rss_news/11077180/12_original.jpg)
=OR(AND(A1>10, A2>10), A3>20)
NOT: æ¡ä»¶ãå転ãããïŒçãªãåœãåœãªãçãªã©ïŒ
NOTé¢æ°ã¯ãæ¡ä»¶ãå転ãããããã®é¢æ°ã§ãTRUEïŒçïŒãFALSEïŒåœïŒã«ãFALSEïŒåœïŒãTRUEïŒçïŒã«å€æããŸããäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=NOT(æ¡ä»¶)
A1ãšA2ã«ããæ°å€ããšãã«10以äžã®å Žåã«TRUEïŒçïŒãè¿ããããã§ãªãå Žåã«ã¯FALSEïŒåœïŒãè¿ãåŒãããå Žåã次ã®ããã«ANDé¢æ°ãšNOTé¢æ°ã䜿çšããŠããã®çµæãå転ãããããšãã§ããŸãã
![NOT: æ¡ä»¶ãå転ãããïŒçãªãåœãåœãªãçãªã©ïŒ1](https://img2.bakusai.com/p/img/rss_news/11077180/13_original.jpg)
=NOT(AND(A1<=10, A2<=10))
ãã®åŒãå ¥åãããšãA1ãšA2ã«ããæ°å€ããšãã«10以äžã®å Žåã«ã¯TRUEïŒçïŒã衚瀺ããããã以å€ã®å Žåã«ã¯FALSEïŒåœïŒã衚瀺ãããŸãã
ãã»ã«æ€çŽ¢ãã§ãããã®ãExcelã®ãã䜿ãé¢æ°äžèŠ§
VLOOKUPãªã©ã®é¢æ°ã䜿ãããšã§ãExcelå ã®èšå€§ãªããŒã¿ãã»ã«æ€çŽ¢ããŠååŸããåç §ãããšãã£ãããšãã§ããŸããããå ·äœçã«ãäž»èŠãªé¢æ°ãšçšäŸãèŠãŠãããŸãããã
COUNT: æå®ããç¯å²å ã®ã»ã«ã®åæ°ãã«ãŠã³ããã
COUNTé¢æ°ã¯ãæå®ããç¯å²å ã®ã»ã«ã®åæ°ãã«ãŠã³ãããããã®é¢æ°ã§ããäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=COUNT(ç¯å²)
äŸ1ïŒA1ããA5ãŸã§ã®ã»ã«ã«ããæ°å€ã®ãã¡ã0ãå«ãã»ã«ã®åæ°ãã«ãŠã³ããã
![COUNT: æå®ããç¯å²å
ã®ã»ã«ã®åæ°ãã«ãŠã³ããã1](https://img2.bakusai.com/p/img/rss_news/11077180/14_original.jpg)
=COUNTIF(A1:A5, 0)
äŸ2ïŒA1ããA10ãŸã§ã®ã»ã«ã«ããæ°å€ãšããã¹ãã®ãã¡ã空æ¬ã§ãªãã»ã«ã®åæ°ãã«ãŠã³ããã
![COUNT: æå®ããç¯å²å
ã®ã»ã«ã®åæ°ãã«ãŠã³ããã2](https://img2.bakusai.com/p/img/rss_news/11077180/15_original.jpg)
=COUNTA(A1:A10)
COUNTIF: æå®ããæ¡ä»¶ã«äžèŽããã»ã«ã®åæ°ãã«ãŠã³ããã
COUNTIFé¢æ°ã¯ãæå®ããæ¡ä»¶ã«äžèŽããã»ã«ã®åæ°ãã«ãŠã³ãããããã®é¢æ°ã§ããäžè¬çã«ã¯æ¬¡ã®ãããªåœ¢åŒãåããŸãã
ã»=COUNTIF(ç¯å², æ¡ä»¶)
ã»äŸ1ïŒA1ããA5ãŸã§ã®ã»ã«ã«ããæ°å€ã®ãã¡ã3以äžã®å€ãå«ãã»ã«ã®åæ°ãã«ãŠã³ããã
![COUNTIF: æå®ããæ¡ä»¶ã«äžèŽããã»ã«ã®åæ°ãã«ãŠã³ããã1](https://img2.bakusai.com/p/img/rss_news/11077180/16_original.jpg)
=COUNTIF(A1:A5, “<=3”)
ã»äŸ2ïŒA1ããA10ãŸã§ã®ã»ã«ã«ããããã¹ãã®ãã¡ã”apple”ãšäžèŽããã»ã«ã®åæ°ãã«ãŠã³ããã
![COUNTIF: æå®ããæ¡ä»¶ã«äžèŽããã»ã«ã®åæ°ãã«ãŠã³ããã2](https://img2.bakusai.com/p/img/rss_news/11077180/17_original.jpg)
=COUNTIF(A1:A10, “apple”)
VLOOKUP: æå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸãã
VLOOKUPé¢æ°ã¯ãæå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸããããã®é¢æ°ã§ãã
ããšãã°ãA1ããB10ãŸã§ã«ããããŒãã«ãããA1ã«å ¥åããæååã«äžèŽããBåã®å€ãååŸãããå Žåã次ã®ããã«VLOOKUPé¢æ°ã䜿çšããŸãã
![VLOOKUP: æå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸãã1](https://img2.bakusai.com/p/img/rss_news/11077180/18_original.jpg)
=VLOOKUP(A1,A:B,2,FALSE) ã
ãã®åŒãå
¥åãããšãA1ã«å
¥åããæååã«äžèŽããBåã®å€ã衚瀺ãããŸããããšãã°çåŸã®ãã¹ãçµæãéèšããAåãææ°ã®ãã¹ãçµæãBåãååã®ãã¹ãçµæãç¹æ°ãè¯ããªã£ãŠããããæªããªã£ãŠãããã調ã¹ãããšãã£ãéã«äœ¿ããŸã
VLOOKUPé¢æ°ã¯ã·ãŒããè·šãã§äœ¿ãããšãå¯èœã§ããããå ·äœçãªäœ¿ãæ¹ãç¥ãããå Žåã¯ã以äžã®èšäºãåèã«ããŠãã ããã
ãªããåŒæ°ã®æå³ã¯ä»¥äžã®éãã§ãã
ã»æ€çŽ¢å€ïŒæ€çŽ¢ããå€ãæå®ããŸããããã§ã¯ãA1ã«å
¥åããæååãæå®ããŸãã
ã»æ€çŽ¢ç¯å²ïŒæ€çŽ¢ããç¯å²ãæå®ããŸããããã§ã¯ãA1ããB10ãŸã§ã®ç¯å²ãæå®ããŸãã
ã»åçªå·ïŒæ€çŽ¢çµæãè¿ãåçªå·ãæå®ããŸããããã§ã¯ãBåãæå®ãã2ãå
¥åããŸãã
ã»äžèŽåïŒæ€çŽ¢å€ãšå®å
šã«äžèŽããå Žåã«TRUEããã以å€ã®å Žåã«FALSEãæå®ããŸããããã§ã¯ãå®å
šäžèŽãæå®ããããã«FALSEãå
¥åããŸãã
 INDEX/MATCH: æå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸããïŒVLOOKUPãããæè»æ§ãããïŒ
INDEX/MATCHé¢æ°ã¯ãVLOOKUPé¢æ°ãããæè»æ§ããããæå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸããããã®é¢æ°ã§ããINDEX/MATCHé¢æ°ã¯ãMATCHé¢æ°ã䜿çšããŠæ€çŽ¢å€ã®äœçœ®ãç¹å®ããINDEXé¢æ°ã䜿çšããŠå¯Ÿå¿ããå€ãååŸããŸãã
ããšãã°ãA1ããB10ãŸã§ã«ããããŒãã«ãããA1ã«å ¥åããæååã«äžèŽããBåã®å€ãååŸãããå Žåã次ã®ããã«INDEX/MATCHé¢æ°ã䜿çšããŸãã
![INDEX/MATCH: æå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸããïŒVLOOKUPãããæè»æ§ãããïŒ1](https://img2.bakusai.com/p/img/rss_news/11077180/21_original.jpg)
=INDEX(B:B, MATCH(A1, A:A, 0))
INDEX/MATCHé¢æ°ã䜿çšããŠãè€æ°ã®æ¡ä»¶ã«äžèŽããã»ã«ã®å€ãååŸã§ããŸããããšãã°ãA1ããC10ãŸã§ã®ããŒãã«ãããA1ã«å ¥åããæååãšB1ã«å ¥åããæ°å€ã®äž¡æ¹ã«äžèŽããCåã®å€ãååŸãããå Žåã次ã®ããã«INDEX/MATCHé¢æ°ã2å䜿çšããŸãã
![INDEX/MATCH: æå®ããæ¡ä»¶ã«åºã¥ããŠã»ã«ã®å€ãååŸããïŒVLOOKUPãããæè»æ§ãããïŒ2](https://img2.bakusai.com/p/img/rss_news/11077180/22_original.jpg)
=INDEX(C:C, MATCH(1, (A:A=A1)*(B:B=B1), 0))
ããšãã°å¡Ÿã®çåŸã«ãåå§ååããè€æ°åãããšããŸãããæ±æ ¡ã®çŽ°å· 倪éãã®ç¹æ°ãæ£ç¢ºã«éèšããããšãã£ãå Žåã«éåžžã«äŸ¿å©ã§ãã
èŠããŠãããšäŸ¿å©ãªè€æ°ã®é¢æ°ã®çµã¿åããäžèŠ§
 IFé¢æ°ãšSUMé¢æ°
IFé¢æ°ãšSUMé¢æ°ãçµã¿åãããããšã§ãæå®ããæ¡ä»¶ã«å¿ããŠå€ãåèšã§ããŸãã
äŸïŒAåãå šå£²äžãBåãåºèåãCåã顧客å±æ§ãšãããBåã”暪æµåº”ãã€Cåã”ãªããŒã¿ãŒ”ãšãªã£ãŠããè¡ã®Aåã®å€ãåèšãã
![IFé¢æ°ãšSUMé¢æ°1](https://img2.bakusai.com/p/img/rss_news/11077180/23_original.jpg)
=SUM(IF((B2:B6=”暪æµåº”)*(C2:C6=”ãªããŒã¿ãŒ”), A:A))
VLOOKUPé¢æ°ãšIFERRORé¢æ°
VLOOKUPé¢æ°ã䜿çšããŠãæ€çŽ¢å€ãç¯å²å ã«ååšããªãå Žåã®ãšã©ãŒãåé¿ã§ããŸãã
ããšãã°ãA1ããB10ãŸã§ã®ããŒãã«ãããA1ã«å ¥åããæååã«äžèŽããBåã®å€ãååŸãããå Žåã次ã®ããã«IFERRORé¢æ°ã䜿çšããŠãæ€çŽ¢å€ãç¯å²å ã«ååšããªãå Žåã«ã¯”not found”ãšè¡šç€ºããããã«ããŸãã
![VLOOKUPé¢æ°ãšIFERRORé¢æ°1](https://img2.bakusai.com/p/img/rss_news/11077180/24_original.jpg)
=IFERROR(VLOOKUP(A1, A:B, 2, FALSE), “not found”)
ãã®åŒãå ¥åãããšãA1ã«å ¥åããæååã«äžèŽããBåã®å€ã衚瀺ãããŸãããã ããæ€çŽ¢å€ãç¯å²å ã«ååšããªãå Žåã«ã¯”not found”ã衚瀺ãããŸãã
ããšãã°ããªã³ãŽçµãšã¢ã¢çµã¯ã»ããã§è¡åãããããããçµãšãã¹ã«ããçµã¯ã»ããã§è¡åããããšãã£ãçµã¿åãã«äŸ¿å©ã§ããnot foundããåºåãããå Žåã¯çµã¿åããããŸããã£ãŠããªãçµããããšå€å®ã§ããŸãã
ãŸãšã
Excelã§åå¿è ã®æ¹ã«ããããã®é¢æ°ã解説ããŸããã売äžããµã€ãæµå ¥ãªã©ã®åæããä»å玹ä»ããSUMé¢æ°ãAVERAGEé¢æ°ãªã©åæ©çãªé¢æ°ãåæãšããŠäœ¿ãå Žåãå€ãã§ãããŸãæååæäœãã§ããé¢æ°ã¯é¡§å®¢ãªã©ã®åŸååæãå簿管çã«äŸ¿å©ã§ãã®ã§ããã²äœ¿ã£ãŠã¿ãŠãã ããã
â»ãµã ãã€ã«ç»åïŒImage:PixieMe / Shutterstock.comïŒ