<![CDATA[
<P> </P>
<P><iframe id="RaCb_DpZ1fY$@my" width="640" height="360" src="https://kakaotv.daum.net/embed/player/cliplink/RaCb_DpZ1fY$@my?service=daum_cafe&ptoken=v2_32d727645260419cfcbefb4719fd34bad0b68cca2409247c3befb949826c33cafecc1f01469304f0ff3d437a1eb1172fd6012921dc07c9071a49e63e" frameborder="0" scrolling="no" allowfullscreen></iframe></P>
<P> </P>
<TABLE style="WIDTH: 443pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=589 border=0>
<COLGROUP>
<COL style="WIDTH: 95pt" width=126>
<COL style="WIDTH: 48pt" width=64>
<COL style="WIDTH: 160pt" width=213>
<COL style="WIDTH: 140pt" width=186></COLGROUP>
<TBODY>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); WIDTH: 95pt; BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=126 height=18><STRONG><FONT face="맑은 고딕" color=#000000 size=2>청소당번정하기(2)</FONT></STRONG></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); WIDTH: 48pt; BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent" width=64><STRONG></STRONG><BR></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); WIDTH: 160pt; BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent" width=213><STRONG><FONT face="맑은 고딕" color=#000000 size=2>VLOOKUP함수</FONT></STRONG></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); WIDTH: 140pt; BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent" width=186><FONT face="맑은 고딕" color=#000000 size=2>V (수직: VERTICAL)</FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><BR></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>LOOKUP (찾는 것)</FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=3 height=18><STRONG><FONT face="맑은 고딕" color=#000000 size=2>번호를 알면 이름도 나타내고 싶을 때 사용</FONT></STRONG></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><STRONG></STRONG><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><STRONG></STRONG><BR></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><STRONG></STRONG><BR></TD>
<TD class=xl68 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><STRONG></STRONG><BR></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>F9 누르면 (재계산 키)</FONT></TD></TR>
<TR style="HEIGHT: 20.25pt" height=27>
<TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: yellow" height=27><FONT face="맑은 고딕" color=#000000 size=2><STRONG>오늘의 청소당번은?</STRONG></FONT></TD>
<TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: red">
<P style="TEXT-ALIGN: center"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG>4</STRONG></FONT></P></TD>
<TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: rgb(79,129,189)">
<P style="TEXT-ALIGN: center"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG>김형돈</STRONG></FONT></P></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG></STRONG></FONT><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#ffffff size=5><STRONG></STRONG></FONT><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG></STRONG></FONT><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG></STRONG></FONT><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=5><STRONG></STRONG></FONT><BR></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD class=xl75 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 16.5pt; BACKGROUND-COLOR: red" colSpan=2 height=22><FONT face="맑은 고딕" color=#ffffff size=3><STRONG>=RANDBETWEEN(1,5)</STRONG></FONT></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=3><STRONG></STRONG></FONT><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=3><STRONG></STRONG></FONT><BR></TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22><FONT face="맑은 고딕" color=#ffffff size=3><STRONG></STRONG></FONT><BR></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#ffffff size=3><STRONG></STRONG></FONT><BR></TD>
<TD class=xl74 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: rgb(79,129,189)"><STRONG><FONT face="맑은 고딕" color=#ffffff size=3>=VLOOKUP(B5,A10:B14,2,0)</FONT></STRONG></TD>
<TD class=xl73 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><STRONG></STRONG><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: rgb(31,73,125)" height=18><FONT face="맑은 고딕" color=#ffffff size=2>번호</FONT></TD>
<TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: rgb(31,73,125)"><FONT face="맑은 고딕" color=#ffffff size=2>성명</FONT></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#000000 size=2>1</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>김영철</FONT></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#000000 size=2>2</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>이순재</FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#000000 size=2>3</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>장동건</FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#000000 size=2>4</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>김형돈</FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><FONT face="맑은 고딕" color=#000000 size=2>5</FONT></TD>
<TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT face="맑은 고딕" color=#000000 size=2>유재석</FONT></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18><BR></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD class=xl67 style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD>
<TD style="BORDER-RIGHT: rgb(236,233,216); BORDER-TOP: rgb(236,233,216); BORDER-LEFT: rgb(236,233,216); BORDER-BOTTOM: rgb(236,233,216); BACKGROUND-COLOR: transparent"><BR></TD></TR></TBODY></TABLE>
<P><BR></P>
<!-- -->
]]>
카페 게시글
엑셀 함수 공부하기
VLOOKUP함수 - 세로방향으로 찾기
가고파
추천 0
조회 79
10.01.12 13:07
댓글 1
다음검색
첫댓글 재밌어요^^연예인들 청소시키니까요^^