°∇엑셀 A행 값이 같을 경우 B, C행 자동채우기 질문이요//°∇

°∇엑셀 A행 값이 같을 경우 B, C행 자동채우기 질문이요//°∇ <IMG style="WIDTH: 485px; HEIGHT: 710px" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fblogfiles.naver.net%2F20100202_186%2Fkorgilbert_1265084606912fz8o5_jpg%2Fbaf1bec6b1d7b6f3_a501501_korgilbert.jpg">A행:이름   B행:주민번호         C행:주소차카타          (빈셀)                 (빈셀)사아자          (빈셀)                 (빈셀)가나다          (빈셀)                 (빈셀)사아자          (빈셀)                 (빈셀) . . . . . . . . .가나다        123-456        가나라마바사아라마바        789-123        자차카타바하가사아자        234-522        나다라마바사아차카타        854-785        자차카타파하가타파하        782-482        나다라마바사아 이런식으로 A행에 이름만 죽 입력이 되어있고 (순서 랜덤)맨 아래에 A, B, C 행에 이름, 주민번호, 주소 이렇게 입력이 되어있을 때A행의 값이 같을 경우 B, C행 값을 자동으로 채우는 방법 좀 알려주세요//<답변>질문에 대한답변입니다. <table style="WIDTH: 184pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="245" x:str=""><colgroup><col style="WIDTH: 60pt" width="80"><col style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 2417" width="85"><col style="WIDTH: 60pt" width="80"></colgroup><tbody><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 60pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18" width="80">가</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23" width="85">주민1</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" width="80">주소1</td></tr><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18">나</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23">주민2</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22">주소2</td></tr><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18">다</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23">주민3</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22">주소3</td></tr><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18">라</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23">주민4</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22">주소4</td></tr><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18">마</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23">주민5</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22">주소5</td></tr><tr style="HEIGHT: 13.5pt" height="18"><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22" height="18">바</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl23">주민6</td><td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl22">주소6</td></tr></tbody></table>  가 라는부분을 A1으로 하고 주소 6을 C6 으로.. A8 에 "가" 입력 주민등록번호=VLOOKUP(A8,$A:$1:$C$6,2)주소=VLOOKUP(A8,$A:$1:$C$6,3) 도움되셨길 바랍니다. * 게시물 출처 : <a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=102020101&docId=101341557&qb=YQ==&enc=utf8&section=kin&rank=80&sort=0&spq=1">http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=102020101&docId=101341557&qb=YQ==&enc=utf8&section=kin&rank=80&sort=0&spq=1</a>