°Ê²¼¤Î¤è¤¦¤Êɽ¤¬£²¤Ä¤¢¤ë¤È¤·¤Þ¤ó¤Í¤ó¡£
¡Ú£Á¥Õ¥¡¥¤¥ë¡Û
¥»¥ë¡¡A B C
1¹ÔÌÜ ¾¦ÉÊ⡡ʬÎà⡡̾¾Î
2¹ÔÌÜ 11¡¡¡¡¡¡21¡¡¡¡¡¡£Á£Â£Ã
3¹ÔÌÜ 12¡¡¡¡¡¡22¡¡¡¡¡¡£Ä£Å£Æ
4¹ÔÌÜ 13¡¡¡¡¡¡23¡¡¡¡¡¡£Ç£È£É
¡Ú£Â¥Õ¥¡¥¤¥ë¡Û
¥»¥ë¡¡A B C¡¡¡¡¡¡ D E
1¹ÔÌÜ ¾¦ÉÊ⡡ʬÎà⡡̾¾Î¡¡¡¡¥³¡¼¥É¡¡¶â³Û
2¹ÔÌÜ 1 2 ¤¢¤¤¤¦¡¡11000¡¡ 100
3¹ÔÌÜ 11¡¡¡¡¡¡21¡¡¡¡¡¡¤«¤¤¯¡¡55000¡¡ 200
4¹ÔÌÜ 3¡¡¡¡¡¡ 4 ¤µ¤·¤¹¡¡90000 300
¡Ö£Á¥Õ¥¡¥¤¥ë¡×¤Î¾¦ÉÊâ¡ÜʬÎàâ¤È°ìÃפ¹¤ë¥Ç¡¼¥¿¤ò¡Ö£Â¥Õ¥¡¥¤¥ë¡×¤«¤é¸¡º÷¤ò¤·¤Æ¡¢¤½¤Î¹Ô¤´¤È¤ËÊÌ¥Õ¥¡¥¤¥ë¤ËÃê½Ð¤¹¤ë´Ø¿ô¤Ê¤ó¤Æ¤¤¤¦¤Î¤Ï¤¢¤ë¤Ç¤Ã¤·¤ã¤í¤«¡©
°ìÃפ¹¤ë¤Î¤ÏÊ£¿ô¹Ô¤¢¤ë¤È»×¤¦¤Î¤Ç¡¢Ê£¿ôÃê½Ð¤¹¤ëÊýË¡¤Ê¤ó¤«¤â¤¢¤ì¤Ð¶µ¤¨¤Æ¤¤¤¿¤À¤¤¿¤¤¤ä¡£
¤Á¤¦¤è¤¦¤Ê¼ÁÌ䤬¤¢¤ë¤È¤·¤Þ¤ó¤Í¤ó¡£
¤Á¡¼¤È¤Ð¤«¤·Ê£»¨¤À¤È¤Ï»×¤ª¤ë¤±¤É¥À¥ó¤µ¤ó¡¢°Ê²¼¤Î´Ø¿ô¤ò»²¹Í¤Ë¤·¤Æ¤ß¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£
£±¡¥ÊÌ¥Õ¥¡¥¤¥ë¤Ë¥·¡¼¥È̾¡Ö¸¡º÷¾ò·ï¡×¤Á¤¦¥·¡¼¥È¤òºîÀ®¤·¤Þ¤ó¤Í¤ó¡£
£²¡¥¥·¡¼¥È¡Ö¸¡º÷¾ò·ï¡×¤Î£Á£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Â£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$B$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Ã£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Ä£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$D$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Å£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$E$2¡×
¡¡¡¡¤ÈÆþÎϤ·¤Æ¤ª¤¤Þ¤ó¤Í¤ó¡£¤³¤ì¤Ï¡¢£Å£²¤Î¼¡¤Ï£Æ¡¦£Ç¡¦£È¡¦¡¦¡¦¡¦¤ÈɬÍפÊʬ¤À¤±Æ±¤¸¤è¤¦¤Ë´Ø¿ô¤ò¥³¥Ô¡¼¤·¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£
£³¡¥£±¹ÔÌܤ˺¸Í㦤«¤é¡Ö¾¦ÉÊNo¡×¡ÖʬÎàNo¡×¡Ö¾¦ÉÊ̾¡×¡Ö¥³¡¼¥É¡×¡Ö¶â³Û¡×¤È̾Á°¤òÆþ¤ì¤Æ¤ª¤¤Þ¤ó¤Í¤ó¡£
£´¡¥Ãê½Ð¸µ¤Î¥Ç¡¼¥¿¤¬¤¢¤ë¥·¡¼¥È¤Ë°Ü¤Ã¤Æ¡¢¡Ö¾¦ÉÊâ¡×¤Î£±¹ÔÌܤνê¤Ë¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"¾¦ÉÊNo",¸¡º÷¾ò·ï!A1:C2)¡×¤ÈÆþÎϤ·¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£¤³¤³¤Ç¤¤¤¦¡Ö***¡×¤Á¤¦¤Î¤Ï¡Ö£²¡×¤Ç»ØÄꤷ¤¿ºÇ½ª¹Ô¤ÎÈÖ¹æ¤Ë¤Ê¤ë¤ó¤ä¡£
£µ¡¥¼¡¤Ë¡ÖʬÎàâ¡×¤Î£±¹ÔÌÜ¡§¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"ʬÎàNo",¸¡º÷¾ò·ï!A1:C2)¡×
¡¡¡¡¡¡¡¡¡Ö¾¦ÉÊ̾¡×¤Î£±¹ÔÌÜ¡§¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"ʬÎàNo",¸¡º÷¾ò·ï!A1:C2)¡×
¡¡¡¡¡¡¡¡¡Ö¥³¡¼¥É¡×¤Î£±¹ÔÌÜ¡§¡Ö=VLOOKUP(C2,[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$1:$E$***,2,FALSE)¡×
¡¡¡¡¡¡¡¡¡Ö¶â³Û¡×¡¡¤Î£±¹ÔÌÜ¡§¡Ö=VLOOKUP(C2,[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$1:$E$***,3,FALSE)¡×
¡¡¡¡¤ÈÆþÎϤ·¤Þ¤ó¤Í¤ó¡£
¤³¤ì¤ÇÂç¾æÉפÀ¤È»×¤¦¤Î¤Ç¡¢»²¹Í¤Ë¤Ê¤µ¤Ã¤Æ¤ß¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¤Í¡£
¡Ú£Á¥Õ¥¡¥¤¥ë¡Û
¥»¥ë¡¡A B C
1¹ÔÌÜ ¾¦ÉÊ⡡ʬÎà⡡̾¾Î
2¹ÔÌÜ 11¡¡¡¡¡¡21¡¡¡¡¡¡£Á£Â£Ã
3¹ÔÌÜ 12¡¡¡¡¡¡22¡¡¡¡¡¡£Ä£Å£Æ
4¹ÔÌÜ 13¡¡¡¡¡¡23¡¡¡¡¡¡£Ç£È£É
¡Ú£Â¥Õ¥¡¥¤¥ë¡Û
¥»¥ë¡¡A B C¡¡¡¡¡¡ D E
1¹ÔÌÜ ¾¦ÉÊ⡡ʬÎà⡡̾¾Î¡¡¡¡¥³¡¼¥É¡¡¶â³Û
2¹ÔÌÜ 1 2 ¤¢¤¤¤¦¡¡11000¡¡ 100
3¹ÔÌÜ 11¡¡¡¡¡¡21¡¡¡¡¡¡¤«¤¤¯¡¡55000¡¡ 200
4¹ÔÌÜ 3¡¡¡¡¡¡ 4 ¤µ¤·¤¹¡¡90000 300
¡Ö£Á¥Õ¥¡¥¤¥ë¡×¤Î¾¦ÉÊâ¡ÜʬÎàâ¤È°ìÃפ¹¤ë¥Ç¡¼¥¿¤ò¡Ö£Â¥Õ¥¡¥¤¥ë¡×¤«¤é¸¡º÷¤ò¤·¤Æ¡¢¤½¤Î¹Ô¤´¤È¤ËÊÌ¥Õ¥¡¥¤¥ë¤ËÃê½Ð¤¹¤ë´Ø¿ô¤Ê¤ó¤Æ¤¤¤¦¤Î¤Ï¤¢¤ë¤Ç¤Ã¤·¤ã¤í¤«¡©
°ìÃפ¹¤ë¤Î¤ÏÊ£¿ô¹Ô¤¢¤ë¤È»×¤¦¤Î¤Ç¡¢Ê£¿ôÃê½Ð¤¹¤ëÊýË¡¤Ê¤ó¤«¤â¤¢¤ì¤Ð¶µ¤¨¤Æ¤¤¤¿¤À¤¤¿¤¤¤ä¡£
¤Á¤¦¤è¤¦¤Ê¼ÁÌ䤬¤¢¤ë¤È¤·¤Þ¤ó¤Í¤ó¡£
¤Á¡¼¤È¤Ð¤«¤·Ê£»¨¤À¤È¤Ï»×¤ª¤ë¤±¤É¥À¥ó¤µ¤ó¡¢°Ê²¼¤Î´Ø¿ô¤ò»²¹Í¤Ë¤·¤Æ¤ß¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£
£±¡¥ÊÌ¥Õ¥¡¥¤¥ë¤Ë¥·¡¼¥È̾¡Ö¸¡º÷¾ò·ï¡×¤Á¤¦¥·¡¼¥È¤òºîÀ®¤·¤Þ¤ó¤Í¤ó¡£
£²¡¥¥·¡¼¥È¡Ö¸¡º÷¾ò·ï¡×¤Î£Á£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Â£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$B$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Ã£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Ä£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$D$2¡×
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£Å£²¥»¥ë¡§¡Ö=[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$E$2¡×
¡¡¡¡¤ÈÆþÎϤ·¤Æ¤ª¤¤Þ¤ó¤Í¤ó¡£¤³¤ì¤Ï¡¢£Å£²¤Î¼¡¤Ï£Æ¡¦£Ç¡¦£È¡¦¡¦¡¦¡¦¤ÈɬÍפÊʬ¤À¤±Æ±¤¸¤è¤¦¤Ë´Ø¿ô¤ò¥³¥Ô¡¼¤·¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£
£³¡¥£±¹ÔÌܤ˺¸Í㦤«¤é¡Ö¾¦ÉÊNo¡×¡ÖʬÎàNo¡×¡Ö¾¦ÉÊ̾¡×¡Ö¥³¡¼¥É¡×¡Ö¶â³Û¡×¤È̾Á°¤òÆþ¤ì¤Æ¤ª¤¤Þ¤ó¤Í¤ó¡£
£´¡¥Ãê½Ð¸µ¤Î¥Ç¡¼¥¿¤¬¤¢¤ë¥·¡¼¥È¤Ë°Ü¤Ã¤Æ¡¢¡Ö¾¦ÉÊâ¡×¤Î£±¹ÔÌܤνê¤Ë¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"¾¦ÉÊNo",¸¡º÷¾ò·ï!A1:C2)¡×¤ÈÆþÎϤ·¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¡£¤³¤³¤Ç¤¤¤¦¡Ö***¡×¤Á¤¦¤Î¤Ï¡Ö£²¡×¤Ç»ØÄꤷ¤¿ºÇ½ª¹Ô¤ÎÈÖ¹æ¤Ë¤Ê¤ë¤ó¤ä¡£
£µ¡¥¼¡¤Ë¡ÖʬÎàâ¡×¤Î£±¹ÔÌÜ¡§¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"ʬÎàNo",¸¡º÷¾ò·ï!A1:C2)¡×
¡¡¡¡¡¡¡¡¡Ö¾¦ÉÊ̾¡×¤Î£±¹ÔÌÜ¡§¡Ö=DGET([¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$A$1:$E$***,"ʬÎàNo",¸¡º÷¾ò·ï!A1:C2)¡×
¡¡¡¡¡¡¡¡¡Ö¥³¡¼¥É¡×¤Î£±¹ÔÌÜ¡§¡Ö=VLOOKUP(C2,[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$1:$E$***,2,FALSE)¡×
¡¡¡¡¡¡¡¡¡Ö¶â³Û¡×¡¡¤Î£±¹ÔÌÜ¡§¡Ö=VLOOKUP(C2,[¡Ú£Â¥Õ¥¡¥¤¥ë¡Û]Sheet1!$C$1:$E$***,3,FALSE)¡×
¡¡¡¡¤ÈÆþÎϤ·¤Þ¤ó¤Í¤ó¡£
¤³¤ì¤ÇÂç¾æÉפÀ¤È»×¤¦¤Î¤Ç¡¢»²¹Í¤Ë¤Ê¤µ¤Ã¤Æ¤ß¤Æ¤ª¤¯¤ó¤Ê¤Ï¤ì¤Í¡£










