¾È³çÇϼ¼¿ä °í°´´Ô
ºñÁîÆû ¼½ÄÁö¿ø¼ºñ½º ´ã´çÀÚÀÔ´Ï´Ù.
´Ü°¡ ¼ö½Ä ÀçÀÔ·Â Çصå·È½À´Ï´Ù.
ÃßÈÄ °°Àº ¹®Á¦°¡ ÀÖÀ» °æ¿ì ´Ü°¡ ¼¿¿¡ ¾Æ·¡ ¼ö½ÄÀ» ÀÔ·ÂÇØ ÁÖ½Ã¸é µË´Ï´Ù.
=IFERROR(IF(B9="","",IF(C9="¸ÅÀÔ",VLOOKUP(E9,Ç°¸ñ¹üÀ§,3,0),VLOOKUP(E9,Ç°¸ñ¹üÀ§_¸ÅÃâ,3,0))),"")
´Ù¸¥ ¹®ÀÇ»çÇ×ÀÌ ÀÖÀ¸½Ã¸é [¼½ÄÁö¿ø¼ºñ½º]¸¦ ÅëÇØ
¹®ÀÇÇØ Áֽøé Á¤¼º²¯ ´äº¯ µå¸®°Ú½À´Ï´Ù.
¸ñ·Ïº¸±â>
|