is this possible ?

  • Thread starter Thread starter Ms_M_o_n_i_c_a
  • Start date Start date
M

Ms_M_o_n_i_c_a

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
 
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
 
YESSSSSSSSSSSSSSS!
thank you so much.
I also saved that websie to my favorite.
 
Good to hear.

Keep Debra's site bookmarked as you have.

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


Gord
 
Back
Top