인덱스 매치함수 관련질문입니다

<table width="464" style="width: 348pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3168;"><colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3264;"><colgroup><col width="72" style="width: 54pt;"><colgroup><col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3328;"><colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 2784;"><tbody><tr height="33" style="height: 24.75pt; mso-height-source: userset;"><td width="99" height="33" style="border: 0.5pt solid windowtext; border-image: none; width: 74pt; height: 24.75pt; background-color: rgb(221, 235, 247);">구간</td><td width="102" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 77pt; background-color: rgb(221, 235, 247);">번호</td><td width="72" style="border: 0px black; border-image: none; width: 54pt; background-color: transparent;"></td><td width="104" style="border: 0.5pt solid windowtext; border-image: none; width: 78pt; background-color: transparent;">구간기준</td><td width="87" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 65pt; background-color: transparent;">번호기준</td></tr><tr height="33" style="height: 24.75pt; mso-height-source: userset;"><td height="33" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 34px; background-color: transparent;">서울~부산</td><td align="center" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; height: 34px; background-color: transparent;">#N/A</td><td style="border: 0px black; border-image: none; height: 34px; background-color: transparent;"></td><td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 34px; background-color: transparent;"><a name="RANGE!F5:F8">서울~부산</a></td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; height: 34px; background-color: transparent;"><a name="RANGE!G5:G8">             1 </a></td></tr><tr height="33" style="height: 24.75pt; mso-height-source: userset;"><td height="33" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 24.75pt; background-color: transparent;">서울-청주</td><td align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">2</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: transparent;">서울-청주</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">             2 </td></tr><tr height="33" style="height: 24.75pt; mso-height-source: userset;"><td height="33" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 24.75pt; background-color: transparent;">대전~광주</td><td align="center" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">#N/A</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: transparent;">대전~광주</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">             3 </td></tr><tr height="33" style="height: 24.75pt; mso-height-source: userset;"><td height="33" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 24.75pt; background-color: transparent;">대구-전주</td><td align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">4</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: transparent;">대구-전주</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">             4 </td></tr></tbody></table> 안녕하세요?'=INDEX(번호기준,MATCH(A2,구간기준,0))위와 같이 인덱스, 매치 함수 사용시 물결표는 인식이 안되는 이유가 궁금합니다.해결방법이 있는지도 궁금합니다 기초데이터를 임의로 "~" 에서 "-" 로 변경 할 수 없는 상황이라서요감사합니다

카페정보

엑셀전문가클럽

실버 (공개)
카페지기 부재중
회원수 19,817
방문수3
카페앱수31

카페 전체 메뉴

▲

카페 게시글

묻고 답하기 인덱스 매치함수 관련질문입니다

심심한하루 추천 0 조회 362 16.09.03 14:53 댓글 2

게시글 본문내용

다음검색

저작자 표시 컨텐츠변경 비영리

이군악
16.09.03 21:13

첫댓글 ~는 match함수에서 예약된 특수 문자이기 때문이라서 그래요.
match함수에서 찾는 값에다가 서울~~부산 이렇게 ~를 한 번 더 써주면 되요.
심심한하루
작성자 16.09.09 11:43

답변 감사드립니다 ^^ 근데 찾는값을 임의로 바꿀수가 없거든요 ㅜㅜ

검색 옵션 선택상자

댓글내용선택됨 옵션 더 보기

댓글내용

댓글 작성자

연관검색어

환율

환자

환기

최신목록

https://cafe.daum.net/funnyexcel

카페 전체 메뉴