how do i enable a drop down list depending on result of "if" funct
 

Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for the
sub activities related to the chosen main activity.

how do i enable a drop down list depending on result of "if" funct
 

Hi

Have a look here for dependent drop-downs:
http://www.contextures.com/xlDataVal02.html

Hope this helps.

Andy.

"Varun" wrote in message
...
Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once
user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for
the
sub activities related to the chosen main activity.

how do i enable a drop down list depending on result of "if" f
 

Hey buddy
This really helped. Thanx a ton.
I owe u one

Bye

"Andy" wrote:

Hi

Have a look here for dependent drop-downs:
http://www.contextures.com/xlDataVal02.html

Hope this helps.

Andy.

"Varun" wrote in message
...
Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once
user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for
the
sub activities related to the chosen main activity.

how do i enable a drop down list depending on result of "if" f
 

Thanks for the feedback! Glad to help.

Andy.

"Varun" wrote in message
...
Hey buddy
This really helped. Thanx a ton.
I owe u one

Bye

"Andy" wrote:

Hi

Have a look here for dependent drop-downs:
http://www.contextures.com/xlDataVal02.html

Hope this helps.

Andy.

"Varun" wrote in message
...
Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once
user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list
for
the
sub activities related to the chosen main activity.