[Year 12 IT Apps] oooops forgot the attachment

[Bradley Owens]

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.

Brad Owens
IT Faculty Coordinator
Maranatha Christian School
(Ph) 03 9709 7245  (Fax) 03 9706 1910
________________________________
From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] On Behalf Of Lesley Humphries [humples at santamaria.vic.edu.au]
Sent: Monday, 25 June 2007 9:55 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] oooops forgot the attachment

Here is the offending Excel file with the misbehaving vlookup
___________________________________________________________
Ms Lesley Humphries
IT Faculty Co-ordinator
Santa Maria College
50 Separation Street
Northcote 3070
Ph: 9489 7644
___________________________________________________________
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 _______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070625/03993c42/attachment.html