Thought I'd better try this out on my collegue first - at least it works to some degree. Jens N. Outzen Senior Commercial Analyst Paddington Station 0207 298 7300 ext 243 ----- Forwarded by Jens Outzen/South East/FirstGroup on 20/09/2005 12:05 ----- Jens Outzen To: Barry Marshall/South East/FirstGroup@FIRSTGROUP 20/09/2005 11:45 cc: Subject: test |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |NEW | | | | | | | |Type | Capital| Op lease| Depreciation| | | | | | | | | | | cost| | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Bus type | | 0| | | | | |Trident | 166000| 2101.56| 28.88| |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Cost each | | £0| Operating | £0| | | | Artic| 200000| 2532.00| 34.80| | | | |lease cost per| | | | | | | | | | | | | month | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Interst rate| | 8.00%| | HP over| 5 |years | |Gemini | 166000| 2101.56| 28.88| |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| | Life | | 12 | Residual | 5.00%| | | |Dart | 120000| 1519.20| 26.10| | | | | | | | | |Long | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Annual | | £0 |Annual | £0| | | | Dart| 115000| 1455.90| 25.01| |depreciation| | |operating | | | | | Short| | | | |per bus | | |lease each > | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Capital cost| | £0| |Cost | £0| | |Dart Med| 115000| 1455.90| 25.01| | | | | |over 5 | | | | | | | | | | | | |years > | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |Annual | £0| |Annual | £0| | | | Dart| 115000| 1455.90| 25.01| |depreciation| | |operating | | | | | Slim| | | | | | | |lease > | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| | Net | £0| |% of capital | 0%| | | | Optare| 87000| 1101.42|(Embedded | | book | | |cost | | | | | | | |image moved | | value| | | | | | | | | | |to file: | | after| | | | | | | | | | |pic14604.jpg)| | 5 | | | | | | | | | | | | | years| | | | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| |% of capital| 0%| | | | | | | Enviro| 118000| 1493.88| 25.66| |cost | | | | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| | | | | | | | | | | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| | | | | | | | | |Gemini | 15|Per £1000| | | | | | | | | | |life | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| | | | | | | | | |Dart | 12| 12.66| | | | | | | | | | |life | | | | |------------+------------+--------------+--------------+--------+----------------+--------+--------+--------+----------+---------+-------------| The above is a calculation that would tell me the cost implication on a bus whether depreciation or operational lease was chosen. What I would like to do is to refer to the cell "Bus type" (here shown as "0") and use a vlookup in the "cost each" cell (the vlookup to refer to the table on your far right). However, currently the only list there is (apart from the typed one here to the right) to refer to is a drop down menu and I can't find anyway - apart from using a large number of "IF" statements - to utilise the drop down menu. I am trying not to have to retype the table somewhere else. Am I just being lazy or is there a way I can use the drop down menu ???? Jens N. Outzen Senior Commercial Analyst Paddington Station 0207 298 7300 ext 243 ********************************************************************** This message is confidential. It may not be disclosed to, or used by, anyone other than the addressee. If you receive this message in error, please advise us immediately. Internet email is not necessarily secure. First does not accept responsibility for changes to any email which occur after the email has been sent. Attachments to this email could contain software viruses which could damage your system. First have checked the attachments for viruses before sending, but you should virus-check them before opening. For more information on our range of services or to book your tickets online, please visit:- http://www.firstgroup.com ********************************************************************** -- No attachments (even text) are allowed -- -- Type: image/jpeg -- File: pic14604.jpg ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************