How to make a Cell look for another cell value then call up a drop down?

Hi All

Is there a way to create a multiple dropdown (Similar to Windows Start menu) so that the user can select the item and its properties then the selections be placed into multiple cells? For example, i select wood from drop down list and i get another drop down list asking for the type of wood, I select MDF and another drop down ask for thickness. when I finished my selections, then the selected Items copy themselves into 3 different cells. Please see attached JPG file. Any help is much appreciated.

Cheers

ADSK

HI all

I have a drop down in (A1) cell and I select an item from it. I want (A2) cell to check the name in (A1) then call up another drop down i already made in (A2). Is that possible? If yes can you please tell me how to do that?

Thanks

ADSK

Originally Posted by ADSK

HI all

I have a drop down in (A1) cell and I select an item from it. I want (A2) cell to check the name in (A1) then call up another drop down i already made in (A2). Is that possible? If yes can you please tell me how to do that?

Thanks
ADSK

I don't know about A2 checking anything, but here is some info on Dependant drop down menus
http://www.contextures.com/xlDataVal02.html

Thank you for the link. I am already using INDIRECT formy list. Let me explain what I done and what I need

I have a list of Materials (ex. wood, Metal, Glass, Fabric, etc...) in A1 cell
I created other dropdowns for all of the items in this list and used =INDIRECT(A1) command to link them together. they show in (A2) cell

So when I select Wood from the first drop down (A1), the second dropdown (A2) automatically calls for Wood list (ex. Maple, Rosewood, MDF, etc...). If i select Metal in A1, the second drop down (A2) looks for Metal list instead (ex. Stainless Steel, Aluminum, etc...) and so on. As i mentoned, I used =INDIRECT(A1) command to do this.

Now, I have colors and finishes in (A3) for these items. If i use INDIRECT again, It will show me the same results as (A2). I need to tell (A3)cell to look at (A1) and see what is in there first. SO if its wood then call up a dropdown which i made for wood colors in (A3).

Hope I explained it well.

Thanks

See if example is what your after

Cross Dependent Validation Lists

if not try downloading the examples and I sure you will find what your after

VBA Noob

Your welcome.

PS. Please remember to follow forums rules. Duplicate posts are not permitted

VBA Noob

Sheet DataVal cells B3 to D3 have the following formulas refereing to the name ranges

B3 formula =IF(OR(AND(C3<>"",C3<>"N/A"),AND(D3<>"",D3<>"N/A")),Yes,IF(OR(C3="N/A",D3="N/A"),No,Eligible))

C3 formula =IF($B$3="Yes",Dept,NotValid)

Cell D3 formula =IF($B$3="Yes",Months,NotValid)

Name ranges on lists tab

Dept =Lists!$A$1:$A$4
Eligible =Lists!$G$1:$G$2
Months =Lists!$C$1:$C$12
No =Lists!$G$2
NotValid =Lists!$E$1
Yes =Lists!$G$1

HTH

VBA Noob

See if this helps

Cell F4 data validation use

=INDIRECT(D4&"finish")

VBA Noob