<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micro=
soft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" xm=
lns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://www.w=
3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Street"=
/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceType"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:"Bradley Hand ITC";
panose-1:3 7 4 2 5 3 2 3 2 3;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h1
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-align:center;
page-break-after:avoid;
font-size:16.0pt;
font-family:Arial;
text-decoration:underline;}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:14.0pt;
font-family:Arial;
text-decoration:underline;}
h3
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:13.0pt;
font-family:"Times New Roman";
text-decoration:underline;}
h4
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman";
font-weight:normal;
text-decoration:underline;}
h5
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:"Book Antiqua";
font-weight:normal;}
h6
{margin-top:0cm;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:"Comic Sans MS";
font-weight:normal;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:"Bradley Hand ITC";}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin-top:3.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Times New Roman";}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin-top:3.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoDocumentMap, li.MsoDocumentMap, div.MsoDocumentMap
{margin:0cm;
margin-bottom:.0001pt;
background:navy;
font-size:10.0pt;
font-family:Tahoma;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
/* Page Definitions */
@page
{mso-endnote-separator:url("cid:header.htm\@01C7B712.2A640200") es;
mso-endnote-continuation-separator:url("cid:header.htm\@01C7B712.2A640200")=
ecs;}
@page Section1
{size:595.3pt 841.9pt;
margin:2.0cm 2.0cm 2.0cm 2.0cm;
mso-footer:url("cid:header.htm\@01C7B712.2A640200") f1;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:234317045;
mso-list-type:hybrid;
mso-list-template-ids:505722820 201916419 201916419 201916421 201916417 201=
916419 201916421 201916417 201916419 201916421;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1
{mso-list-id:429663360;
mso-list-type:hybrid;
mso-list-template-ids:-299990236 201916417 201916419 201916421 201916417 20=
1916419 201916421 201916417 201916419 201916421;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1285308543;
mso-list-type:hybrid;
mso-list-template-ids:1181796422 201916419 201916419 201916421 201916417 20=
1916419 201916421 201916417 201916419 201916421;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3
{mso-list-id:1553346116;
mso-list-type:hybrid;
mso-list-template-ids:-2021607734 201916417 201916419 201916421 201916417 2=
01916419 201916421 201916417 201916419 201916421;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l4
{mso-list-id:1888032076;
mso-list-type:hybrid;
mso-list-template-ids:-2007497156 201916419 201916419 201916421 201916417 2=
01916419 201916421 201916417 201916419 201916421;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=3DEN-AU link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Lesley<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Try to redefine your named table to not
include the heading.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Another trick is to use “find an
exact match” i.e. add ,false to your vlookup<o:p></o:p></span></font><=
/p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>e.g. =3Dvlookup(C3,rate,2,false)<o:p></=
o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>You use this to get an exact match R=
11;
such as matching suburb and postcode. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Hope this helps<o:p></o:p></span></font=
></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Sue Dunlop<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font size=
=3D3
face=3D"Times New Roman"><span lang=3DEN-US style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span><=
/font></b><font
size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-fam=
ily:Tahoma'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b><s=
pan
style=3D'font-weight:bold'>On Behalf Of </span></b>Lesley Humphries<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, 25 June 2007 9:=
55 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Year 12 IT Applications
Teachers' Mailing List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Year 12 IT Apps] oo=
oops
forgot the attachment</span></font><span lang=3DEN-US><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'>Here is the offending Excel file with the misbehaving vlookup<br>
___________________________________________________________<br>
Ms Lesley Humphries<br>
IT Faculty Co-ordinator<br>
<st1:place w:st=3D"on"><st1:PlaceName w:st=3D"on">Santa Maria</st1:PlaceName=
> <st1:PlaceType
w:st=3D"on">College</st1:PlaceType></st1:place><br>
<st1:Street w:st=3D"on"><st1:address w:st=3D"on">50 Separation Street</st1:a=
ddress></st1:Street><br>
Northcote 3070<br>
Ph: 9489 7644<br>
___________________________________________________________<br>
This email and any attachments may be confidential. You must not disclose or
use the information in this email if you are not the intended recipient. If=
you
have received this email in error, please notify us immediately and delete t=
he
email and all copies. The College does not guarantee that this email is viru=
s
or error free. The attached files are provided and may only be used on the
basis that the user assumes all responsibility for any loss, damage or
consequence resulting directly or indirectly from the use of the attached
files, whether caused by the negligence of the sender or not. The content an=
d
opinions in this email are not necessarily those of the College
_______________________________________________ <br>
<a href=3D"http://www.edulists.com.au"><b><span style=3D'font-weight:bold'>h=
ttp://www.edulists.com.au
</span></b></a>- FAQ, resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href=3D"http://www.vcaa.vic.edu.au"><b><span style=3D'font-weight:bold'>h=
ttp://www.vcaa.vic.edu.au
</span></b></a>- Victorian Curriculum and Assessment Authority and <br>
<a href=3D"http://www.vitta.org.au"><b><span style=3D'font-weight:bold'>http=
://www.vitta.org.au
</span></b></a>- VITTA Victorian Information Technology Teachers Association
Inc<o:p></o:p></span></font></p>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confident=
ial. If received in error, please contact us and delete all copies. Before o=
pening or using attachments check them for viruses and defects. Regardless o=
f any loss, damage or consequence, whether caused by the negligence of the s=
ender or not, resulting directly or indirectly from the use of any attached=
files our liability is limited to resupplying any affected attachments. Any=
representations or opinions expressed are those of the individual sender, a=
nd not necessarily those of the Department of Education.</p></body>
</html>