ÅÓÌ´¶¿¤É¤Ã¤Èº®¤à

¿ÆÉã¤Î¸¢°Ò¡¦ExcelÊÔ

º£½Õ¤«¤é¼Ò²ñ¿Í¤Ë¤Ê¤ë¸µµª¤Ç¤¹¤¬¡¢´ë¶È¤ËÄó½Ð¤¹¤ë½ÉÂ꤬´ö¤Ä¤«¤¢¤ë¤é¤·¤¯¡¢¤½¤ÎÃæ¤ËMicrosoft¤ÎExcel¤ò»È¤¦²ÝÂ꤬¤¢¤ê¡¢¥Ø¥ë¥×¤òµá¤á¤é¤ì¤¿¤Î¤Ç¡¢¤Á¤ç¤Ã¤È¼êÅÁ¤Ã¤Æ¤¢¤²¤Þ¤·¤¿¡£VLOOKUP´Ø¿ô¤ò»È¤¦ÆâÍƤǤ·¤¿¤¬¡¢¤Á¤ç¤¦¤É¿ô¥ö·îÁ°¡¢¼«Ê¬¤¬´Ø¤ï¤Ã¤¿°Æ·ï¤Ç»È¤Ã¤¿¤Ð¤«¤ê¤À¤Ã¤¿¤Î¤Ç¡¢¤ªÃã¤Î»Ò¤µ¤¤¤µ¤¤¡ª ¥É¥ä´é¤ÇÂбþ½ÐÍè¤Þ¤·¤¿¡Ê¾Ð¡Ë¡£

VLOOKUP´Ø¿ô¤Ï"¥Ç¡¼¥¿¤ò»²¾È¤¹¤ë"´Ø¿ô¤Ç¤¹¤¬¡¢¡Ö=VLOOKUP(¸¡º÷ÃÍ¡¤ÈÏ°Ï¡¤ÎóÈֹ桤¸¡º÷ÊýË¡)¡×¤Èɽµ­¤µ¤ì¤Æ¤â¼è¤ÃÉÕ¤­¤Ë¤¯¤¤¤·Ê¬¤«¤ê¤Å¤é¤¤¤Î¤Ç¤¹¡£"¸¡º÷ÃÍ"¡¢"ÎóÈÖ¹æ"¤Ê¤ó¤Æ½ñ¤­Êý¤Ê¤Î¤ÇËÜÅö¤Ëʬ¤«¤ê¤Å¤é¤¤¤Î¤Ç¤¹¤¬¡¢Íפϡ¢¡Ö"¤É¤ÎÎó¤Î¿ô»ú"¤ò¸«¤Æ¡¢»²¾È¤¹¤ëÈϰϤΰìÃפ¹¤ëÃ椫¤é"º¸¤«¤é²¿ÎóÌܤÎÃÍ"¤òɽ¼¨¤µ¤»¤ë¤«¡×¤Ê¤Î¤Ç¤¹¡£ÆäËʬ¤«¤ê¤Å¤é¤¤¤Î¤¬"ÎóÈÖ¹æ"¤ÎÍý²ò¡£

¤Þ¤¿¡¢Ä̾盧¤Î¼ê¤Îɽ¤òºî¤ë»þ¤Ï1¹Ô¤À¤±¤Ç½ª¤ï¤ë¤³¤È¤Ï¤Ê¤¯²¿¹Ô¤Ë¤âÅϤë¤Î¤Ç¤¹¤¬¡¢³Æ¹Ô¤Ë´Ø¿ô¤ò¤¤¤Á¤¤¤Áµ­Æþ¤·¤Æ¤¤¤ë¤È»þ´Ö¤Ð¤«¤ê³Ý¤«¤ë¤Î¤Ç¿ô¼°¤ò¥³¥Ô¡¼¡õ¥Ú¡¼¥¹¥È¡Ê¥³¥Ô¥Ú¡Ë¤·¤Þ¤¹¤¬¡¢Excel¤Î¥³¥Ô¥Ú¤Î¥»¥ë¾ðÊó¤Î³µÇ°¤ÏÁêÂÐÃͤʤΤǡ¢°ì¹Ô²¼¤Ë¥³¥Ô¥Ú¤È¤¹¤ë¤È¡¢»²¾È¤¹¤Ù¤­ÈϰϤâ°ì¹Ô¥º¥ì¤Á¤ã¤¦¤Î¤Ç¤¹¡£¤½¤ì¤ò²óÈò¤¹¤ë¤Î¤¬ÀäÂкÂɸ¤Î³µÇ°¤Ç¡¢¥»¥ë¤Î¥¢¥É¥ì¥¹¤ÎÁ°¤Ë"$"¥Þ¡¼¥¯¤òÉÕ¤±¤ë¡ÊŬµ¹¡¢¹Ô¤«Îó¡¢°¿¤¤¤ÏξÊý¡Ë¤È¥º¥ì¤â̵¤¯¤Ê¤ê¤Þ¤¹¡£

ºòǯËö¤Ë»ä¤¬²ÝÂê¤ò¥Á¥ç¥Á¥ç¥¤¥Î¥Á¥ç¥¤¤Ç¸¯¤Ã¤Á¤ã¤Ã¤¿»þ¤Ë¤Ï¥¤¥Þ¥¤¥Áʬ¤«¤é¤Ê¤«¤Ã¤¿¤è¤¦¤Ç¡¢¡Ö¤¢¤ì¤¸¤ã¼«Ê¬¤¬Íý²ò½ÐÍè¤Æ¤¤¤Ê¤«¤Ã¤¿¤«¤é¡¢º£ÅÙ¤ÏÁ´Éô¼«Ê¬¤¬¸¯¤ë¡×¤È¤Î¤³¤È¤À¤Ã¤¿¤Î¤Ç¡¢ºòÆü¤ÏÈब¸¯¤ë¤Î¤ò²£¤Ç¸«¤Æ¤¤¤Æ¡¢Æäˡ¢ÀäÂкÂɸ¡ÊÀäÂл²¾È¡Ë¤Î¹Í¤¨Êý¤òÅÁ¼ø¤·¤Þ¤·¤¿¡£¤Ä¤¤¤Ç¤Ë¡¢¥³¥Ô¥Ú¤Î´Êñ¤ÊÊýË¡¤È¤·¤Æ¡¢¥»¥ë¤ÎÏȤᦲ¼¤Ë¥«¡¼¥½¥ë¤ò»ý¤Ã¤Æ¤­¤Æ¡¢É½¼¨¤¬"+"¤Ë¤Ê¤Ã¤¿¤È¤³¤í¤Ç²¼¤Ë¥É¥é¥Ã¥°¤¹¤ë¤È¡¢¤½¤ÎÈϰϤËÁ´Éô¥Ú¡¼¥¹¥È¤µ¤ì¤ë¤³¤È¤â¡£Â礤¤Ë´¶¿´¤µ¤ì¤Þ¤·¤¿¡ª

¤½¤Î¤¢¤È¡¢¡Ö¼¡¤Î²ÝÂê¤Ï¥Ô¥Ü¥Ã¥È¥Æ¡¼¥Ö¥ë¡¢¡¢¡¢¡×¤È¸À¤Ã¤Æ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢¥Ô¥Ü¥Ã¥È¥Æ¡¼¥Ö¥ë¤Ï»²¾È¤¹¤ë¤±¤É¼«Ê¬¤Ç¤Ïºî¤Ã¤¿¤³¤È̵¤¤¤Î¤Ç¡¢¡Ö¤¢¤È¤Ï¼«Ê¬¤ÇÊÙ¶¯¤·¤í¡×¤ÈÁ³¤ê¤²¤Ê¤¯ÅÁ¤¨¤Þ¤·¤¿¡Ê¾Ð¡Ë¡£