<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta content="MSHTML 6.00.2900.3132" name="GENERATOR">
<style title="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body ocsi="x">
<div dir="ltr"><font face="Tahoma" color="#000000" size="2">I think it's because you have included your headings (Position and Rate) in the named range Hourly_Rate. If you change that range to not include the headings it works fine.</font></div>
<div>
<div><font face="Tahoma" size="2"></font> </div>
<div><font face="Tahoma" size="2">Brad Owens</font></div>
<div><font face="tahoma" size="2">IT Faculty Coordinator</font></div>
<div><font face="tahoma" size="2">Maranatha Christian School</font></div>
<div><font face="tahoma" size="2">(Ph) 03 9709 7245 (Fax) 03 9706 1910</font></div>
</div>
<div id="divRpF832866" style="DIRECTION: ltr">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b> itapps-bounces@edulists.com.au [itapps-bounces@edulists.com.au] On Behalf Of Lesley Humphries [humples@santamaria.vic.edu.au]<br>
<b>Sent:</b> Monday, 25 June 2007 9:55 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] oooops forgot the attachment<br>
</font><br>
</div>
<div></div>
<div>Here is the offending Excel file with the misbehaving vlookup<br>
___________________________________________________________<br>
Ms Lesley Humphries<br>
IT Faculty Co-ordinator<br>
Santa Maria College<br>
50 Separation 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 the email and all copies.
The College does not guarantee that this email is virus 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 and opinions in this email are not necessarily those of the College _______________________________________________
<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au </a>
- FAQ, resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au" target="_blank">http://www.vcaa.vic.edu.au </a>
- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au </a>- VITTA Victorian Information Technology Teachers Association Inc</div>
</body>
</html>