See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"will07" wrote in message
...
I want to use a drop down menu in a cell that will look up a list that
will
have different categories in it. My question, can I filter these
categores
in the drop down menu : i.e

Paint (cat name)
walls (list name)
ceilings (list name
Plaster (cat name)
single side ( list name)

Hope this all makes sense (and there is an way of achieving it)

Thanks