¡ÖWeb½ÐÈÇ¥µ¥¤¥È¡×¥Ù¡¼¥¿¸ø³«

Q&A½¸[¡©]

Åö¥µ¥¤¥È¤Ç¤Î¤´¼ÁÌä¤Î¼õÉդϽªÎ»¤·¤Þ¤·¤¿

¤¹¤Ù¤Æ¤Î¥³¥ó¥Æ¥ó¥Ä¤òÆÉ¤ß¹þ¤ßÀìÍѤȤ·¤¿¤¿¤á¡¢²óÅúÍ󤫤é¤âÅê¹Æ¤Ç¤­¤Þ¤»¤ó

Apache OpenOffice/LibreOffice¤Î¤´¼ÁÌä¤Ï¤½¤ì¤¾¤ì¤Î¥Õ¥©¡¼¥é¥à¤Ø¤´Åê¹Æ¤¯¤À¤µ¤¤

¼ÁÌ䥳¡¼¥Ê¡¼

¥µ¥¤¥ÈÆâ¸¡º÷

ʬÎà¥á¥Ë¥å¡¼

´ØÏ¢¥µ¥¤¥È


ËÜÆü¡§2
ºòÆü¡§2
Áí¿ô¡§2282
¸½ºß¡§3


lookup´Ø¿ô¤Ç#N/A¥¨¥é¡¼¤¬É½¼¨¤µ¤ì¤Þ¤¹

¥Ú¡¼¥¸OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸
Åê¹Æ¼Ô¤Ï¤Ã¤·
ʬÎà
edit/refer
Í¥Àè½ç°Ì
edit/refer
¾õÂÖ
edit/refer
¥«¥Æ¥´¥ê¡¼
edit/refer
Åê¹ÆÆü2010-06-20 03:09:56 (Æü)
OSxp sp3
°Í¸¤¹¤ë¥Ú¡¼¥¸
¥Ð¡¼¥¸¥ç¥ó
edit/refer

¥á¥Ã¥»¡¼¥¸

²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó

¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£

°Ê²¼¤Î¤è¤¦¤Êɽ¤ÇÃͤˤè¤Ã¤Æ#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@¶å½£ÍÍÄ󼨤ÎÊýË¡¤ò»î¤·¤Æ¤ß¤¿¤È¤³¤í¤¦¤Þ¤¯¤¤¤­¤Þ¤·¤¿¡£

¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£¤Þ¤¿¡¢²¿¤«¤¢¤Ã¤¿¤éµ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£

¤ªÌ¾Á°:
Âê̾: