lookup´Ø¿ô¤Ç#N/A¥¨¥é¡¼¤¬É½¼¨¤µ¤ì¤Þ¤¹ †
¥Ú¡¼¥¸ | OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸ |
---|---|
Åê¹Æ¼Ô | ¤Ï¤Ã¤· |
ʬÎà | |
Í¥Àè½ç°Ì | |
¾õÂÖ | |
¥«¥Æ¥´¥ê¡¼ | |
Åê¹ÆÆü | 2010-06-20 03:09:56 (Æü) |
OS | xp sp3 |
°Í¸¤¹¤ë¥Ú¡¼¥¸ | |
¥Ð¡¼¥¸¥ç¥ó |
¥á¥Ã¥»¡¼¥¸ †
²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó |
¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£
°Ê²¼¤Î¤è¤¦¤Êɽ¤ÇÃͤˤè¤Ã¤Æ#N/A¥¨¥é¡¼¤¬É½¼¨¤·¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¥¨¥é¡¼¤¬É½¼¨¤·¤Æ¤·¤Þ¤¦¸¶°ø¤È²óÈòÊýË¡¤ò¤´¶µ¼ø´ê¤¤¤Þ¤¹¡£
¡¡ A¡¡¡¡B¡¡¡¡C¡¡¡¡D¡¡¡¡E
1¡¡1¡¡¡¡2¡¡¡¡3¡¡¡¡4¡¡¡¡5
2¡¡1¡¡¡¡3¡¡¡¡2¡¡¡¡4¡¡¡¡5
3¡¡1¡¡¡¡3¡¡¡¡4¡¡¡¡2¡¡¡¡5
4¡¡4¡¡¡¡1¡¡¡¡2¡¡¡¡5¡¡¡¡3
5
6¡¡¡¡¡¡¡ý¡¡ (a)¡¡(b)¡¡(c)
7¡¡¡¡¡ 1¡¡¡¡1¡¡¡¡1¡¡¡¡#N/A
8¡¡¢¡¡ 2¡¡¡¡1¡¡¡¡1¡¡¡¡#N/A
9¡¡£¡¡ 4¡¡¡¡4¡¡¡¡3¡¡¡¡1
A1¤«¤éE1¤Ï½ç°Ì¤Îɽ¼¨¤Ç¤¹¡£
A2¤«¤éE4¤ÏÆþÎÏÍѤÎɽ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
B7¤«¤éB9¤Ë¤Ï¾ò·ï¤Ë¤è¤ê¿ôÃͤòÆþÎϤ·¤Þ¤¹¡£
¤½¤ì¤Ëȼ¤Ã¤ÆC7¤«¤éE9¤Ë¾ò·ï¸¡º÷¤µ¤ì¤¿¿ôÃͤ¬É½¼¨¤µ¤ì¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤Þ¤¹¡£
lookup´Ø¿ô¤ÏC7¤«¤éE9¤Ë¤Ï¤¤¤Ã¤Æ¤¤¤Þ¤¹¡£
C7 LOOKUP(B7;A2:E2;A1:E1)) D7 LOOKUP(B7;A3:E3;A1:E1)) E7 LOOKUP(B7;A4:E4;A1:E1))
C8 LOOKUP(B8;A2:E2;A1:E1)) D8 LOOKUP(B8;A3:E3;A1:E1)) E8 LOOKUP(B8;A4:E4;A1:E1))
C9 LOOKUP(B9;A2:E2;A1:E1)) D9 LOOKUP(B9;A3:E3;A1:E1)) E9 LOOKUP(B9;A4:E4;A1:E1))
ËÜÍè¤Îɽ¼¨¤Ï²¼¤Î¤è¤¦¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
¡¡ ¡¡ A¡¡¡¡B¡¡¡¡C¡¡¡¡D¡¡¡¡E
6¡¡¡¡¡¡¡¡¡¡¡ý¡¡(a)¡¡(b)¡¡(c)
7¡¡¡¡¡¡¡¡¡1¡¡¡¡1¡¡¡¡1¡¡¡¡2
8¡¡¡¡¢¡¡¡¡2¡¡¡¡3¡¡¡¡4¡¡¡¡3
9¡¡¡¡£¡¡¡¡4¡¡¡¡4¡¡¡¡3¡¡¡¡1
#N/Aɽ¼¨¤À¤±¤Ç¤Ï¤Ê¤¯C8,D8¤Ïɽ¼¨¤â°ã¤Ã¤Æ¤Þ¤¹¡£
¤³¤ì¤ÏC8,D8¤À¤±¤Ç¤Ï¤Ê¤¯¡¢ÆþÎϤµ¤ì¤ë¿ôÃͤˤè¤Ã¤Æ¤ÏC7¡ÁE9¤Î¤É¤³¤Ç¤â¤Ê¤ê¤Þ¤¹¡£
¤Þ¤¿¡¢¿ôÃͤÎʤӤˤè¤Ã¤Æ¤Ï¤¹¤Ù¤ÆÀµ¾ï¤Ëɽ¼¨¤µ¤ì¤ë¾ì¹ç¤â¤¢¤ê¤Þ¤¹¡£
¸¶°ø¤¬¤ï¤«¤é¤Ê¤¤¤¿¤áÂбþ¤Î¤·¤è¤¦¤¬¤Ê¤¯º¤¤Ã¤Æ¤¤¤Þ¤¹¡£
¤É¤¦¤«µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¾º½ç¤¬É¬¿Ü¤Ê LOOKUP ¤Ï»È¤ï¤Ê¤¤»ö †
ike@¶å½£ (2010-06-20 09:40:47 (Æü))
http://oooug.jp/faq/index.php?faq%2F5%2F385
¤ÈƱ¤¸¤Ç¡¢¾º½ç¤Ëʤó¤Ç¤¤¤Ê¤¤¤¿¤á¤Ç¤¹¡£
¾º½ç¤Ç¤Ê¤¯¤Æ¤â»ÈÍѤǤ¤ë HLOOKUP ¤ä VLOOKUP ¤¬»ÈÍѤǤ¤ë¤è¤¦¤Ëɽ¤ò¹©Éפ¹¤ë¤«¡¢ MATCH ¤È INDEX ¤ÎÁȤ߹ç¤ï¤»¤ò»È¤¤¤Þ¤¹¡£
C7
=INDEX($A$1:$E$1;1;MATCH($B7;$A$2:$E$2;0))
D7
=INDEX($A$1:$E$1;1;MATCH($B7;$A$3:$E$3;0))
E7
=INDEX($A$1:$E$1;1;MATCH($B7;$A$4:$E$4;0))
¸å¤Ï²¼¤Ø¥É¥é¥Ã¥°¥³¥Ô¡¼¤·¤Þ¤¹
faq/5/385¤ÈƱ¤¸Íýͳ †
M.Kamataki (2010-06-20 12:03:39 (Æü))
¤Ï¤¤¡¢ike@¶å½£¤µ¤ó¤Î¤´»ØÅ¦¤Î¤È¤ª¤ê¤À¤È»×¤¤¤Þ¤¹¡£
LOOKUP´Ø¿ô¤ò»È¤¦¤Ê¤é¡¢C7¡¢C8¡¢C9¤Ë¤Ä¤¤¤Æ¤Ï¡¢´ðËÜŪ¤Ë¤ÏA1:E4¤Îɽ¤ò2¹ÔÌܤò¥¡¼¤Ë¾º½ç¤ÇʤÙÂØ¤¨¤ë¤Ù¤¤Ç¤¹¤Í¡£
ƱÍͤËD7¡¢D8¡¢D9¤Ï¡¢A1:E4¤Îɽ¤ò3¹ÔÌܤò¥¡¼¤Ë¾º½ç¤ÇʤÙÂØ¤¨¡¢E7¡¢E8¡¢E9¤Ï¡¢A1:E4¤Îɽ¤ò4¹ÔÌܤò¥¡¼¤Ë¾º½ç¤ÇʤÙÂØ¤¨¤ì¤Ð´üÂÔ¤·¤¿Ãͤˤʤê¤Þ¤¹¡£
¤³¤ì¤Ï¡¢Excel¤Ç¤â»ö¾ð¤ÏƱ¤¸¤«¤È»×¤¤¤Þ¤¹¡£
̵Âê †
¤Ï¤Ã¤· (2010-06-20 16:26:13 (Æü))
ike@¶å½£ÍÍ¡¢M.KamatakiÍͤ¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
1¹ÔÌܤ¬´ð½à¤Ç¾º½ç¤Ê¤Î¤Ç2¹ÔÌÜ¡Á4¹ÔÌܤò¾º½ç¤Ë¤¹¤ë¤Î¤ÏÉÔ²Äǽ¤Ê¤¿¤á¡¢
ike@¶å½£ÍÍÄ󼨤ÎÊýË¡¤ò»î¤·¤Æ¤ß¤¿¤È¤³¤í¤¦¤Þ¤¯¤¤¤¤Þ¤·¤¿¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£¤Þ¤¿¡¢²¿¤«¤¢¤Ã¤¿¤éµ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£