Using Data/Validation and INDIRECT can achieve this

This is an example
enter values:
G4:= W
G5:= Pears
G6:= Apples
G7:= Oranges
H4:= FB
H5:= Ford
H6:= Honda
H7:= Mercedes

Range Name H5:H7 should be W
Range Name G5:G7 should be FB

select Cell C5
Set Data/Validation to LIST and set Source to G4:H4

select cell D5
set DataValidation to List and the Source to =INDIRECT(C5)

add a change event that will clear D5 if C5 changes
right click the sheet tab, select View Code and paste this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("C5").Address Then
Range("D5") = ""
End If
End Sub



"Kadeycat" wrote in message
...
I would like to have a specific pull down menu appear when an adjacent
cell
has a specific code entered. I have multiple material lists but I don't
want
to have to sort through the entire list every time.
Example: If I want a list of W shaped beams to be available I would enter
a
'W' in the box next to the list. A named range would only be shown in the
drop down list, not the entire table.


=IF(C1="W", =WSHAPES)(C1="FB", =FBSHAPES)

Any guidance will be greatly appreciated.