If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
is this possible ?
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! |
#2
|
|||
|
|||
is this possible ?
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 |
#3
|
|||
|
|||
is this possible ?
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 |
#4
|
|||
|
|||
is this possible ?
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. |
Thread Tools | |
Display Modes | |
|
|