A B C D
1 |
201004 |
201005 |
21006 |
2 |
|
|
|
3 |
=VLOOKUP($A3,[201004.xlsx]Sheet1!C$2:G$16,5,FALSE) |
=VLOOKUP($A3,[201005.xlsx]Sheet1!C$2:G$16,5,FALSE) |
=VLOOKUP($A3,[201006.xlsx]Sheet1!C$2:G$16,5,FALSE) |
|
|
|
|
¿¢¼¿¿¡¼ 1Ä¿¡ ÀÖ´Â µ¥ÀÌÅÍ ÈÀϸíÀ» 3Ä¿¡ Á÷Á¢ ³ÖÁö ¾Ê°í Àμö·Î »ç¿ëÇÏ·Á Çϴµ¥
¾î¶»°Ô ÇØ¾ß Çϳª¿ä. ¾î¶² ÇÔ¼ö¸¦ »ç¿ëÇØ¾ß ÇÏ´ÂÁö¿ä?
=VLOOKUP($A3,[201004.xls]Sheet1!C$2:G$16,5,FALSE) À»
=VLOOKUP($A3,[B1.xls]Sheet1!C$2:G$16,5,FALSE) ÀÌ·±½ÄÀ¸·Î ÇÏ´Ï
¾ÈµÇ´Â±º¿ä .. °í°ßÀ» ºÎŹµå¸³´Ï´Ù,,
(201004 201005 201006 µ¥ÀÌŸ ¸íÀ» °¡Áø ÈÀÏÀº ¹ÙÅÁ ȸ鿡 ±ò·Á ÀÖÀ½)
010-2255-6178
|