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