Struggling with Drop Down Lists

[bloyer]

Hi Everyone,
I've just joined and could really do with some
help any advice/tips/push in the right directions will be very much
appreciated.

I'm currently working on a spread sheet which has two drop down lists a
Main category and a sub-category. Now I only want users to view the
sub-categories that are relevant to the main category they have chosen.
For example if the main was mode of transports and the users chooses car
then the sub will only list types of cars.
This is where I'm stuck I've tried using IF and Lookup formula's then
pointing to the formula via format control but I keep getting errors
(constant value).

Can anyone tell me where I'm going wrong.

Cheers
Rob

 

[Roger Govier]

Hi Rob

Take a look at Debra Dalgleish's site for some easy explanation of what you
are trying to achieve.
http://www.contextures.com/xlDataVal02.html

 

[aaron.kempf]

it truly is about 100 times more powerful in ACCESS.

use a real app for data entry; excel is a joke

 

[bloyer]

Cheers for help.
Had a quick peak at the link and it looks like its gonna sort me out.

For reasons people wont tell me I'm not allowed Access


Cheers again guys
Rob