¾È³çÇϼ¼¿ä °í°´´Ô
ºñÁîÆû ¼½ÄÁö¿ø¼ºñ½º ´ã´çÀÚÀÔ´Ï´Ù.
´Ü°¡ ºÎºÐ ¼ö½ÄÀÌ Áö¿öÁ® ÀÖ¾î ÀçÀÔ·Â Çصå·È½À´Ï´Ù.
ÇØ´ç ¼¿ÀÇ ¼ö½ÄÀº
=IF(ISERROR(VLOOKUP(D10,INDIRECT(C10 & "!C5:D37"),2,FALSE)),"",VLOOKUP(D10,INDIRECT(C10 & "!C5:D37"),2,FALSE))
ÀÔ´Ï´Ù. ÃßÈÄ ¼ö½ÄÀÌ »èÁ¦µÈ °æ¿ì À§ÀÇ ¼ö½ÄÀ» ÀÔ·ÂÇØ ÁÖ½Ã¸é µË´Ï´Ù.
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é [¼½ÄÁö¿ø¼ºñ½º]¸¦ ÅëÇØ
¹®ÀÇÇØ Áֽøé Á¤¼º²¯ ´äº¯ µå¸®°Ú½À´Ï´Ù.
¸ñ·Ïº¸±â>
|