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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering forms data with a drop down box 4
Subforms 3
Formatted cell column in drop down list 1
How does one sort a block of inter-related information in Excel? 1
DATA VALIDATION/DROP DOWN LIST 1
How do I create a drop down box within a drop down box? 1
How do I change contents of a cell based on drop down list selecte 2
validation drop down list question 1

Top