Multiple Data Validation on one cell

[NateCaruso]

I'm building out a form where I'd like a cell to either be unusable or have a dropdown list available depending on the input in the row.

So the example is if the user in cell A3 selects "Yes" I want cell B3 to be unusable similiar to this function =A3<>"Yes".

But if the user in cell A3 selects "No" I want cell B3 to then populate with a list from another sheet in the work book.

I tried to input a IF function that looked like=IF(A3="Yes",<>,!sheet2!A1:A23) but that errored out. Let me know if I'm going about the issue in the right way. I just need to solve for a decision tree to either stop the user from adding more info or have them supply more info.

Thanks for any help!

 

[MarkReddell]

Try This Video from Excelisfun!!! https://www.youtube.com/watch?v=-78bH0RZ7MA

 

[NateCaruso]

So although that works for a case where I have multiple lists that could appear for one cell, in my case its either only one list or blank. I dont want to have to make drop downs with nothing available because other users will think its messed up.

So in Column A the user can select "Make New" "Tie to New from directly above" "Update Existing" "Tie to Existing from directly above"
In Column B if the user chose either "Make New" or "Tie to New from directly above" they would get the same list for a color choice ("blue" "black" "red"). If the user has chosen either "Update Existing" or "Tie to Existing from directly above" the column greys out and I would like to have the field error if anything is input.