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

--
Regards
Roger Govier
"bloyer" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> bloyer
> ------------------------------------------------------------------------
> bloyer's Profile:
> http://www.excelforum.com/member.php...o&userid=25107
> View this thread: http://www.excelforum.com/showthread...hreadid=386136
>

[[email protected]]

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