
VLOOKUP¡¢HLOOKUP´Ø¿ô¤ò»È¤¦»þ¡¢°ú¿ô¤È¤·¤Æ¹ÔÈÖ¹æ¤äÎóÈֹ椬ɬÍפȤʤê¤Þ¤¹¡£
=VLOOKUP( ¸¡º÷ÃÍ , ÈÏ°Ï , ÎóÈÖ¹æ , [¸¡º÷ÊýË¡] )
Ä̾ï¤Ï¤³¤³¤Ë2ÎóÌÜ¡¢3ÎóÌܤȤ¤¤¦¤³¤È¤Ç¿ô»ú¤Î¤ß¤¬Æþ¤ê¤Þ¤¹¤¬¡¢¤½¤ì¤À¤ÈÈÆÍÑÀ¤¬¤Ê¤¤¡¦¡¦¡¦¥³¥Ô¡¼¤·¤ÆÊ̤Υ»¥ë¤ËÄ¥¤êÉÕ¤±¤¿»þ¤Ë¼«Æ°¤ÇÎóÈֹ椬ÊѤï¤Ã¤Æ¤¯¤ì¤Þ¤»¤ó¡£
B2¤Î¼°¤òC2¤Ø¥³¥Ô¡¼¤·¤¿»þ¡¦¡¦¡¦

¤³¤¦¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
ÎóÈֹ椬£²¤Î¤Þ¤ÞÊѤï¤é¤Ê¤¤°Ù¡£
HLOOKUP¡¢VLOOKUP
¤½¤ÎÁ°¤ËHLOOKUP¤ÈVLOOKUP¤Î¤ª¤µ¤é¤¤¤ò¡£
H¤ÈV¤¬¤¢¤ê¤Þ¤¹¤¬¡¢¤½¤ì¤Ï¸¡º÷¤¹¤ëÊý¸þ¤Î°ã¤¤¤Ç¤¹¡£
Î㤨¤Ð²¼¤Î¿Þ¤Ç¤¹¤È¡¢¥³¡¼¥ÉÈÖ¹æ¤Ï½Ä¤Ëʤó¤Ç¤¤¤Þ¤¹¡£¸¡º÷¤¹¤ëÊý¸þ¤È¤¤¤¦¤Î¤Ï½Ä¤Ë¸¡º÷¤·¤Æ¤¤¤¤Þ¤¹¤è¤Í¡£¾å¤«¤é²¼¤Ø¡£¡Ê²£¤Î¾ì¹ç¤Ïº¸¤«¤é±¦¤Ø¡Ë
½Ä¤ÏV¤ò»È¤Ã¤Æ²£¤ÏH¤ò»È¤¤¤Þ¤¹¡£

H¤ÈV¤Î³Ð¤¨Êý¤È¤·¤Æ
½Ä¡á¾å¤«¤é²¼¡á¢¢â²¼Ìð°õ¤Ã¤Ý¤¤¡ÚV¡Û½Ä¡áVLOOKUP¤È»ä¤Ï³Ð¤¨¤Æ¤¤¤Þ¤¹¡£
¤Ç¤Ï¼ÂºÝ¤Ë´Ø¿ô¤Î»È¤¤Êý¤Ç¤¹¤¬¡¢ËÁƬ¤Ë°ú¿ô¤ÎÆâÍÆ¤ò½ñ¤¤¤Æ¤Þ¤¹¤Î¤Ç²ò¤ë¤È¤Ï»×¤¤¤Þ¤¹¤¬¡¢
=VLOOKUP( ¸¡º÷ÃÍ , ÈÏ°Ï , ÎóÈÖ¹æ , [¸¡º÷ÊýË¡] )¸¡º÷ÃÍ ¡¡¡¦¡¦¡¦A2¡Ê¼êÆþÎϤ·¤¿¥³¡¼¥ÉÈֹ桢¸¡º÷¤¹¤ëÃÍ¡Ë
Èϰϡ¡ ¡¡ ¡¦¡¦¡¦E3:G6¡ÊCODEɽ¤ÎÈϰϡ¢¸¡º÷¤¹¤ëÈϰϡË
ÎóÈÖ¹æ ¡¡¡¦¡¦¡¦¸¡º÷Ãͤ¬ÈϰϤÎÃæ¤Ç°ìÃפ·¤¿¤â¤Î¤¬¤¢¤Ã¤¿¤Ð¤¢¤¤¡¢²¿ÎóÌܤò·ë²Ì¤È¤¹¤ë¤«¡£
¡¡¡¡¡¡ ¡¡¡¡¡¡¡¡¡¡EÎó¤ò1ÎóÌܤȤ·¤Æ¹Í¤¨¤ë°Ù¡¢FÎó¤Ï2ÎóÌܤȤʤ롣
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ¥í¡¼¥Þ»ú¤òɽ¼¨¤·¤¿¤«¤Ã¤¿¤é3¤Ë¤¹¤ë¡£
¸¡º÷ÊýË¡¡¦¡¦¡¦¾Êά²Äǽ¤Ç¤¹¤¬¡¢¶á»÷°ìÃפ«´°Á´°ìÃפ«Áª¤Ù¤ë¡£
¡¡¡¡¡¡ ¡¡¡¡¡¡¡¡¡¡´°Á´°ìÃפ·¤¿¾ì¹ç¤Î¤ßÊÖ¤¹¾ì¹ç¤Ï0,¶á»÷¤Ï1¡£
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ¶á»÷¤Ï¿ô»ú¤ò¸¡º÷¤¹¤ë¾ì¹ç¤Ë͸ú¡£
COLUMN¡¢ROW
COLUMN¡¢ROW´Ø¿ô¤È¤Ï =COLUMN( ¥»¥ë»ØÄê )¡¡»ØÄꤷ¤¿¥»¥ë¤¬²¿¹ÔÌÜ¡¦²¿ÎóÌܤ«¤ò¿ô»ú¤ÇÊÖ¤·¤Þ¤¹¡£
COLUMN¤¬Îó¡¢ROW¤¬¹Ô¤Ç¤¹¡£
Î㤨¤Ð¡¡=ROW(D8) ¤Ç¤¢¤ì¤Ð8¹ÔÌܤʤΤÇ8¤È¤Ê¤ê¡¢ =COLUMN(D8)¡¡¤Ç¤¢¤ì¤Ð4ÎóÌܤʤΤÇ4¤¬·ë²Ì¤È¤Ê¤ê¤Þ¤¹¡£
VLOOKUP¤ÈCOLUMN¤òÁȤ߹ç¤ï¤»¤ë

º£²ó¤Î¾ì¹ç¤Ï¤¿¤Þ¤¿¤ÞCOLUMN(B2)¤¬2ÎóÌܤǤԤ俤ê¹ç¤¤¤Þ¤·¤¿¤¬¡¢COLUMN(B2)-1 ¤È¤¤¤¦É÷¤Ë²Ã»»¡¢¸º»»¤·¤Æ¤âÂç¾æÉפǤ¹¡£
¤Á¤ç¤Ã¤È¤·¤¿»ö¤Ç¤¹¤¬¡¢¤Ò¤È¹©Éפ¹¤ë¤À¤±¤Ç¥³¥Ô¡¼¸å¤Î¼ê´Ö¤¬¾Ê¤±¤Þ¤¹¤Í¡£¤³¤ì¤ò»È¤ï¤Ê¤«¤Ã¤¿¤é¡¦¡¦¡¦Å½¤êÉÕ¤±¸å¤Ë¤¤¤Á¤¤¤ÁÎóÈÖ¹æ¤ò¿Í¤Î¼ê¤ÇÊѹ¹¡¦¡¦¡¦¤¢¡¼¤á¤ó¤É¤¯¤µ¤¤¡£
¥³¥á¥ó¥È°ìÍ÷