Excel Help needed

[Origin]

Hello all, I am wondering if it is possible to use a drop down selection list to determine that certain data is shown. I can create the original list, that bit is okay, it is what it does once that selection is made.
EG. Drop down list contains the following:
Ford
Vauxhall
Nissan
etc.

So if a user selects Ford from that list, then in the cells next to it the following appears
Mondeo 2.0L
Escort 1.6
Focus ST
etc
Is this possible or should I be doing it some other way? It doesn't matter if I have to use another program to do, I just thought Excel would be able to do it.

Any help is appreciated.
Cheers

 

[Origin]

You're probably right. What I am actually trying to do, is create a list of Manufacturers that we sell at work and then this would filter down to the Product Manager and also the product specialist aswell.
This would be used by our sales people to find out who they should speak to about particular products. I thought an excel sheet as everyone in the building has excel, but I'm not sure they all have acess unless I could create the DB and then make it a standalone thing that they can just locate on our intranet.

P.S I really did try googling this but got nowhere.
Thanks

 

[Origin]

The data shouldn't change that often, just as and when people leave or move. but that doesn't happen that often at our place.
Thanks again.