Dependant Dropdown Lists not working

[Oldsquid]

I am trying to get 4 dropdown lists to work together, the 2nd (and subsequent) will not work. What am I missing?

[martindwilson]

you have for b3
=INDIRECT(SUBSTITUTE($A$3," ","_")) so when a3 = butt weld you get Butt_Weld but your named range is buttweld
the dropdowns need to resolve to the same name as the named ranges
for that case you would need =INDIRECT(SUBSTITUTE($A$3," ",""))