I want to create a drop down list with only the item & function. Then
depending on what item/function is picked, i need the dept and class and
subclass to appear in 3 seperate cells.

this is the example of my list ....

(item) (function) (dept) (class) (subclass)
Sofa - Stationary, 1086, 1, 1
Sofa - Sleeper, 1086, 1, 2
Loveseat - Stationary, 1086, 2, 1
Loveseat - Sleeper, 1086, 2, 2


--
I will Excel at Excel!

VLOOKUP function could be what you need.

You need a lookup range of at least two columns and a cell for "what" to
lookup.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based
on value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for
inputting Agent ID number..

http://www.contextures.on.ca/xlDataVal01.html

If Sofa and Stationary in separate cells DV with dependent list would be a
good idea.

Also at Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP




On Fri, 1 Aug 2008 15:23:04 -0700, Ms_M_o_n_i_c_a
wrote:

I want to create a drop down list with only the item & function. Then
depending on what item/function is picked, i need the dept and class and
subclass to appear in 3 seperate cells.

this is the example of my list ....

(item) (function) (dept) (class) (subclass)
Sofa - Stationary, 1086, 1, 1
Sofa - Sleeper, 1086, 1, 2
Loveseat - Stationary, 1086, 2, 1
Loveseat - Sleeper, 1086, 2, 2

YESSSSSSSSSSSSSSS!
thank you so much.
I also saved that websie to my favorite.
--
I will Excel at Excel!


"Gord Dibben" wrote:

VLOOKUP function could be what you need.

You need a lookup range of at least two columns and a cell for "what" to
lookup.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based
on value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for
inputting Agent ID number..

http://www.contextures.on.ca/xlDataVal01.html

If Sofa and Stationary in separate cells DV with dependent list would be a
good idea.

Also at Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP




On Fri, 1 Aug 2008 15:23:04 -0700, Ms_M_o_n_i_c_a
wrote:

I want to create a drop down list with only the item & function. Then
depending on what item/function is picked, i need the dept and class and
subclass to appear in 3 seperate cells.

this is the example of my list ....

(item) (function) (dept) (class) (subclass)
Sofa - Stationary, 1086, 1, 1
Sofa - Sleeper, 1086, 1, 2
Loveseat - Stationary, 1086, 2, 1
Loveseat - Sleeper, 1086, 2, 2

Good to hear.

Keep Debra's site bookmarked as you have.

She has a wealth of info there on just about everything.


Gord

On Fri, 1 Aug 2008 16:46:01 -0700, Ms_M_o_n_i_c_a
wrote:

YESSSSSSSSSSSSSSS!
thank you so much.
I also saved that websie to my favorite.