excel advanced question

[Zac]

i have made a dropdown box with diff selections in it. wat i'd like to do is
when one of them is selected i'd like the boxes below that to change name
accordingly. is this possible? if my question is not detailed enough i can
further explain

 

[Jacob Skaria]

If I understand you correctly; you are looking for dependent dropdow list.
Please refer the below link by Debra Dalgleish

on the subject
"Excel -- Data Validation -- Dependent Dropdowns from a Sorted List "
http://www.contextures.com/xlDataVal13.html

"Excel Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

 

[Zac]

thats not exatly wat i was need to do but it was useful non the less. wat i
was talking about was after making a selection in a dropdown, have a form
that lists details about the item previously selected

 

[Gord Dibben]

Maybe a VLOOKUP formula would do the trick?

You will need a two column table with dropdown items and descriptions of
those items.

Then a VLOOKUP formula to return the description for item picked in
dropdown.


Gord Dibben MS Excel MVP