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?