다른시트에서 같은 이름의 데이터 받아오기(VLOOKUP)

<P> <TABLE style="BORDER-RIGHT: #aaaaaa 0px solid; TABLE-LAYOUT: fixed; BORDER-TOP: #aaaaaa 1px solid; BORDER-LEFT: #aaaaaa 0px solid; BORDER-BOTTOM: #aaaaaa 1px solid" cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD style="PADDING-RIGHT: 20px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 3px" align=right><A href="xxjavascript:PlusFont();"><IMG src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fskin%2Fggambo7002_board%2Fimg%2Ffont_plus.gif" border=0></A> <A href="xxjavascript:MinusFont();"><IMG src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fskin%2Fggambo7002_board%2Fimg%2Ffont_minus.gif" border=0></A> <A href="xxjavascript:SetArticleFont();"><IMG src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fskin%2Fggambo7002_board%2Fimg%2Ffont_save.gif" border=0></A> <A href="xxjavascript:SetDefaultFont();"><IMG src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fskin%2Fggambo7002_board%2Fimg%2Ffont_default.gif" border=0></A></TD></TR> <TR> <TD> <DIV id=article style="PADDING-RIGHT: 20px; PADDING-LEFT: 20px; FONT-SIZE: 9pt; PADDING-BOTTOM: 16px; WORD-BREAK: break-all; LINE-HEIGHT: 18pt; PADDING-TOP: 16px; FONT-FAMILY: ; TEXT-ALIGN: left"> <DIV align=left><IMG [안내]태그제한으로등록되지않습니다-oncontextmenu="return copyrightAlert(‎)" [안내]태그제한으로등록되지않습니다-[안내]태그제한으로등록되지않습니다-ondragstart="return false" style="MARGIN: 5px 0px 10px; CURSOR: pointer" [안내]태그제한으로등록되지않습니다-xxonclick=this.src.popupView(); src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fdata%2Ftiptip%2F2006090601.jpg" width=650 [안내]태그제한으로등록되지않습니다-xxonload=resizeImg(this); border=0></DIV> <DIV align=left><IMG [안내]태그제한으로등록되지않습니다-oncontextmenu="return copyrightAlert(‎)" [안내]태그제한으로등록되지않습니다-[안내]태그제한으로등록되지않습니다-ondragstart="return false" style="MARGIN: 5px 0px 10px; CURSOR: pointer" [안내]태그제한으로등록되지않습니다-xxonclick=this.src.popupView(); src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.okitown.pe.kr%2Fzeroboard%2Fdata%2Ftiptip%2F2006090602_1.JPG" [안내]태그제한으로등록되지않습니다-xxonload=resizeImg(this); border=0></DIV>계급별로 또는 순번을 필요로 하는 취합에서..파출소 취합분을 합치다 보면..순번이 엉망이 되어버립니다..<BR>그렇다고 일일이 순번을 부여하자니..시간이 너무 걸리고..<BR>이럴때 사용하면..손쉽게 해결 할 수 있을 것 같습니다.<BR><BR>사용된 함수<BR>=VLOOKUP(C3,파출소취합!$A$2:$B$11,2,FALSE)<BR>  해당 값을 불러옵니다.<BR>=IF(VLOOKUP(C3,파출소취합!$A$2:$B$11,2,FALSE)=0,"",VLOOKUP(C3,파출소취합!$A$2:$B$11,2,FALSE))<BR>  해당 값이 없을 경우 0 이 아닌 빈 공백으로 표시합니다. </DIV></TD></TR></TBODY></TABLE></P>