¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È
- 2008/09/06
- ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ (-)
- ¥³¥á¥ó¥È (-)
- ¢¬

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

Excel¤Ë¤Ï¥Õ¥£¥ë¥¿µ¡Ç½¤È¤¤¤¦¤Î¤¬¤¢¤ê¤Þ¤¹¡£»ØÄꤷ¤¿¥Ç¡¼¥¿¤Î¤ß¤òÃê½Ð¤·É½¼¨¤¹¤ëµ¡Ç½¤Ê¤ó¤Ç¤¹¤¬¡¢¤½¤ÎÃê½Ð¤µ¤ì¤Ê¤«¤Ã¤¿¥Ç¡¼¥¿¤È¤¤¤¦¤Î¤ÏÈóɽ¼¨°·¤¤¤Ç±£¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤¬¡¢Èóɽ¼¨¤µ¤ì¤ë¤À¤±¤Ç¥Ç¡¼¥¿¼«ÂΤϸºß¤·¤Þ¤¹¤Î¤Ç¡¢¤¿¤È¤¨¤Ð¹ç·×¤ò½Ð¤¹SUM´Ø¿ô¤ò»È¤¦¤È¡¢Èóɽ¼¨Éôʬ¤â¹ç·×¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¥Õ¥£¥ë¥¿¤Ë³Ý¤«¤Ã¤¿·ë²Ì¤Î¤ß¡¢É½¼¨¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤Î¤ß¤ò¹ç·×¤·¤¿¤¤¾ì¹ç¤Ï¤É¤¦¤·¤¿¤éÎɤ¤¤ó¤Ç¤·¤ç¤¦¤«¡£