[Year 12 IT Apps] oooops forgot the attachment

[Dunlop, Susan M]

Lesley

Try to redefine your named table to not include the heading.

 

Another trick is to use "find an exact match" i.e. add ,false to your
vlookup

e.g. =3Dvlookup(C3,rate,2,false)

You use this to get an exact match - such as matching suburb and
postcode.  

 

Hope this helps

 

Sue Dunlop

 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Lesley Humphries
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 <http://www.edulists.com.au> - FAQ,
resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au> - Victorian
Curriculum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc


Important - This email and any attachments may be confidential. If received=
 in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070625/cb3014c4/attachment.html