Debra Dalgleish's web site has exactly what you're looking for.

It's called a "Dependent List":

http://www.contextures.com/xlDataVal02.html

http://www.contextures.com/xlDataVal15.html

http://www.contextures.com/xlDataVal13.html
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Benjamin" wrote in message
...
I'm creating an excel sheet with drop-down menus using validations. I'd
like
to create a second row that looks up a list of equipment types from the
first
row's selection. i.e. column 1 = pumps, electrical, vessels.
column 2 = types of pumps,
or types of electrical
or types of vessels.
Is there a way to do this with formulas
or if not how do I do it with code?