Hello all,

I am trying to do something I can't quite figure out.

I am trying to take a selection from a drop down list on one sheet, copy it to another sheet, then use that selection and an IF statement that will then control the drop down list I see. Confusing I am sure... So here is an example as best I can make it at this time.

Real world Example:
Sheet 1
A1 = Drop Down of OS (AIX, LINUX, WINDOWS)

Sheet 2
A1 = Copy of the choice from Sheet 1 - A1 (=IF(LEN(TRIM('Sheet 1'!A1))0,TRIM('Sheet 1'!A1),"")
?? = If statement saying if AIX, then your drop down list is limited to Sheet 3 - A1:A5
A2 = Shows the drop down list utilizing Sheet 3 - A1:A5

Sheet 3
A1:A5 (Text Values)

HELP PLEASE!!!
I have seen the code from the IF statement on, but I can't get the IF statement to work with a drop down selection, it just shows me #VALUE.