Drop Down List Dependent on Cell Value

**Aversin** · 12-05-2013, 02:15 AM

Ok... this is a bit confusing but I'll give it a try...

Cell A1 has a formula that returns one of the 3 possible values "M", "N", "P"
Based off of what value is returned to cell A1 I would like to create a drop down list in Cell B1 that is dependent on that value.

I.E.
If "P" is returned then list "P" will become available as a drop down in that list
If "M" is returned then list "M" will become available
etc...

Then based off of the selection from the returned list i would like to use a vlookup which will reference a table on a second page...

I.E.
"P" is in cell A1 and drop down list "P" in cell B1 has had an item in that list selected, cell C1 will return a numerical value based off of that selection based off of the data table in the second sheet...

Clear as mud? Thoughts?

**NeedForExcel** · 12-05-2013, 02:34 AM

Please attach a sample workbook

Deep

**FDibbins** · 12-05-2013, 02:36 AM

Hi and welcome to the forum

Take a look at the attached, it uses range names for each "set" of values, and then used INDIRECT() to use those values inside the DV

**:) Sixthsense :)** · 12-05-2013, 02:37 AM

Refer the below links for step by step instructions.

http://www.contextures.com/xlDataVal02.html

http://www.contextures.com/xlDataVal13.html

If you cannot able to do it with the help of above links then please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

**Aversin** · 12-05-2013, 05:56 PM

Thanks for everyone's help! You guys rock!

**FDibbins** · 12-05-2013, 05:58 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

**Aversin** · 12-05-2013, 06:01 PM

Sure, now how do I mark it "solved"?

**Aversin** · 12-05-2013, 06:04 PM

Funny what happens when you do a little digging around! Got it. And thanks again everyone!

**Pinkguju** · 08-31-2018, 03:10 PM

I know this is solved but i have a follow up question.

What if i want to use the value that someone copied (or typed) into cell A1?

I have over 1500 values that can go into cell A1 and i want the user to be able to either type or copy it in

Thank you in advance!

Drop Down List Dependent on Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Re: Drop Down List Dependent on Cell Value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE

[SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list

[SOLVED] Code to put today's date in empty cell dependent on selection from drop-down list

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)

Excel 2007 : Data validation drop-down list dependent on another cell

Bookmarks

Bookmarks

Posting Permissions