The issue is pretty simple, but I can't seem to solve it or find an answer.
I have one cell A2 that activates with a yes/no based on what the user enters elsewhere.
I would like to create a drop-down list in another cell A3 only if A2 has a "yes" inside. From what I can tell, this can only be done with Data Validation, but it keeps throwing errors.
Best How To :
With Data Validation for a drop down list, when you are creating it, you can use "If" statements. Choose "List" from "allow", then for the Source, something like
=if(A2="Yes",B2:B6,C2). Note, I assumed that your list of data is B2:B6, and in C2 is some string you want to return if A2 is not "Yes".
Note: If A2 is not "Yes", and you want the list in A3 to then say "No list necessary", you can't just use that string in the IF statement for the validation - you need to put that string in, i.e. C2, and use the formula above. Can't put strings in the data validation IF statement for some reason.