excel advanced question
 

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

excel advanced question
 

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

--
Jacob


"Zac" wrote:

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

excel advanced question
 

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

"Jacob Skaria" wrote:

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

--
Jacob


"Zac" wrote:

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

excel advanced question
 

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

On Fri, 19 Feb 2010 15:19:01 -0800, Zac
wrote:

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

"Jacob Skaria" wrote:

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

--
Jacob


"Zac" wrote:

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