엑셀 셀값 불러오기 함수 관련 문의드립니다.

<p>안녕하세요, 엑셀 함수 관련 문의드립니다. <br><br>아래 사진을 보시면 본명검색기와 참고표가 있습니다. </p><div class="figure-img" data-ke-type="image" data-ke-style="alignCenter" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/1GIVp/bd39d87d4fb138b53d33e6a8fa475fce7de4dcd8" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/1GIVp/bd39d87d4fb138b53d33e6a8fa475fce7de4dcd8" data-origin-width="957" data-origin-height="538"></div><p><br>본명 검색기에서 '참고표'의 별명1,2,3을 '별명'칸(a15~a22)에 수기 입력을 하면 <br>그에 맞는 본명과 지역이 자동적으로 불러와지는 함수가 있을지 궁금합니다. <br><br>a1:c10 이 최종적으로 불러와져야하는 목표인데요, <br>이를 a15:a22 별명을 임력하면 함수로 자동 불러오기가 가능할지 궁금합니다. <br><br>첨부해드린 엑셀파일 확인 부탁드립니다. <br>감사합니다.</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1GIVp/5556efee01222a708f4ff602c28a8715d56676b8?download" data-file-name="예시.xlsx" data-file-size="11402" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1GIVp/5556efee01222a708f4ff602c28a8715d56676b8?download", "/cafeattach/1GIVp/5556efee01222a708f4ff602c28a8715d56676b8", "예시.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D3937%26fileid%3D2%26regdt%3D20210817121513&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1GIVp%2F5556efee01222a708f4ff602c28a8715d56676b8")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">예시</span><span class="type">.xlsx</span></div><div class="size">11.13KB</div></div></a></div>