https://docs.google.com/spreadsheets/d/1R4Fwyi5Xcl4j7LORXzYVk1VpTJO9eSRWvZ_Mf-AAav4/edit?usp=sharing
½ºÇÁ·¹µå½ÃÆ® °ü·ÃÇؼ °í¼öºÐµéÀÇ µµ¿òÀ» ¿äûÇÕ´Ï´Ù! ¤Ð
ÀÏ´Ü À§¿¡ À̹ÌÁö¿¡¼ º¸µí D3ÀÇ 1À» ÂüÁ¶ÇÏ¿©, 1¼øÀ§¿¡ ÇØ´çÇÏ´Â ±¹°¡°¡ ¾îµðÀÎÁö¿¡ ´ëÇÑ °ª ¹ÝȯÀº Á¤»óÀûÀ¸·Î ÀÌ·ç¾î Á³½À´Ï´Ù¸¸
=
INDEX
(
$A$1:$B$82
,
MATCH
(
D3
,
$B$1:$B$3
,
0
)
,
MATCH
(
$E$2
,
$A$1:$A$3
,
0
)
)
¹Ý´ë·Î ±¹°¡¸¦ ÂüÁ¶ÇÏ¿© ¸î ¼øÀ§ÀÎÁö¿¡ ´ëÇÑ °ª ¹ÝȯÀ» ÇÏ°íÀÚ
¾Æ·¡ÀÇ ÇÔ¼ö¸¦ »ç¿ëÇßÁö¸¸, ¼øÀ§°¡ ¾È³ª¿À°í ±¹°¡°¡ ³ª¿É´Ï´Ù ¤Ð ±¸±Û¸µÀ¸·Î µÚÁ®°¡¸é¼ °è¼Ó ¼öÁ¤Çغôµ¥ Àß ¾ÈµÇ³×¿ä. °í¼öºÐµé²²¼ Á¶±Ý¸¸ µµ¿ÍÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù!
Âü°í·Î ÃÖ»ó´Ü¿¡ ´©±¸³ª ¼öÁ¤ÀÌ °¡´ÉÇϵµ·Ï ½ºÇÁ·¹µå½ÃÆ®¿¡ ¼öÁ¤ °øÀ¯±ÇÇÑÀ» ³Ö¾ú½À´Ï´Ù! °ü½É °®¾ÆÁּż °¨»çÇÕ´Ï´Ù.
=
INDEX
(
$A$1:$B$82
,
MATCH
(
D4
,
$A$1:$A$3
,
0
)
,
MATCH
(
$D$2
,
$B$1:$B$3
,
0
)
)