ȸ¿ø ¹æ¹® ¼ö |
8,351,586 ¸í |
Á¢¼Ó Àοø ¼ö |
3,644 ¸í |
| |
|
Ȩ > ¹¯°í´äÇϱâ |
[Re]vlookup ÇÔ¼ö »ç¿ë¹ýÀÌ ¿ÇÀºÁö...^^* |
¾È³çÇϼ¼¿ä.
INDIRECT ÇÔ¼ö´Â ÅؽºÆ®¸¦ ½ÇÁ¦ ¼¿ ÂüÁ¶·Î ¹Ù²Ù´Â ÇÔ¼öÀÔ´Ï´Ù.
µû¶ó¼ VLOOKUP¿¡¼ ÀÌ¿ëÇϽ÷Á¸é VLOOKUP($A7,indirect(¼¿À»Âü°íÇÏ°íÀִ¼¿),5,0)°ú °°ÀÌ
»ç¿ëÇÏ½Ã¸é µË´Ï´Ù.
ÀÚ¼¼ÇÑ »ç¿ë¹æ¹ýÀº [¿¢¼¿ÇÔ¼ö] °ÁÂÀÇ INDIRECT ÇÔ¼öÆíÀ» Âü°íÇϼ¼¿ä.
|
ÀÛ¼ºµÈ ÄÚ¸àÆ®°¡ ¾ø½À´Ï´Ù.
|
| |
|
|
|