Hi,

Im trying to make the selection from one drop down box populate another drop down box using predefined lists and am having some trouble.

=IF(C9=Plasma & PVD,Machines1,IF(C9=Coatings + Furnaces,Furn,""))

This is a shortened version of my code as the complete one has 7 variables but the theory is the same (I think!).

C9 is the first drop down menu and Machines1 and Furn are my lists that I want to populate the second drop down box with.

When I put the code in it says that some ranges are not defined. I have checked all my lists and they are accessed fine so am a little stumped.

I don't know if I need to add some characters to define the C9 output correctly or anything else...

Please help!

Thanks