[Year 12 IT Apps] oooops forgot the attachment

[Paul Miller]

It has something to do with the table. Don't include the headings of the table, just the info and you should find it works nicely! I know, I had the same problem a couple of years ago and was perplexed why vlookup wouldn't do it for me.

See attached!

Paul.

____________________________________
Paul Miller
Our Lady of the Sacred Heart College (OLSH)
111 Jasper Road 
BENTLEIGH 3204
Ph: (03) 9563 9522  Fax: (03) 9563 9484

pmiller at olsh.vic.edu.au
http://www.olsh.vic.edu.au/Sports%20Website/index.htm

>>> Lesley Humphries <humples at santamaria.vic.edu.au> 25/06/2007 9:55 am >>>
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 e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. The College does not guarantee that this e-mail 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 e-mail are not necessarily those of the College.



<<<<GWAVAsig>>>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: HELP!.xls
Type: application/vnd.ms-excel
Size: 13824 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070625/b1f19feb/HELP-0001.xls