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
Bookmarks