Hello,
I am making a sheet as such:
See Picture Capture.PNG
On another sheet (Sheet 2, Column A), I want to be able to select the data from Sheet1 Column A (any number from 1-6), however I would like it so that If I choose 2 in Column A, than Column B only gives me the option to select "Blue" or "Green". I would like this to continue through column C following the same rules, and give me an answer in Column D.
So for Example on Sheet2 Column A I have the options from 1-6. If I select 6 than Column B gives me the options "blue" or "red". If I select "Blue" than Column C gives me the options "Circle" or "Square". If I select Circle than Column D equals Thirteen.
Can anyone help me figure out how to do this?
Thanks!
Bookmarks