I am currently working on a basic booking form using Excel 2007 for use in a small office dealing with a dozen bookings per day.

To speed up the process in the bookings I have created a drop-down list of all the schools that are stored on the database - currently over 2000. For these schools I have all the addresses for them stored on a the spreadsheet.

I would like to know how I can get the addresses for the appropriate schools to appear when a user clicks on that school from the drop-down list - in the address fields below.

One further question, how is possible within the drop down list, for a user to click on a letter of the alphabet and the list goes to that letter - instead of having to scroll down and look for the school?

Many thanks.