Dependant Data Validation to Supply final answer

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!

Hi, welcome to the forum

1st, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

2nd, yes what you want is dalled dependant drop downs. See attached for a sample - it uses named ranges and INDIRECT(). After looking at it, let me know if you need help adapting it to your needs?