What I mean by this is that I want a cell to show a drop-down list (the only kind I know of is from Data Validation) only if another cell (NOT containing Data Validation/drop-down list) has a specific value.
Specifically, I want for example cell B2 to show a drop-down list (for example based on cells C2:C10) only if A2 is not empty AND not equal to 0.
In non-formula terms, this would be something like:
IF A2 is empty THEN B2 is empty ELSE IF A2=0 THEN B2 is empty ELSE B2 shows drop-down list (with data from C2:C10)
I haven't found a formula allowing me to do this. Is there any? To my understanding, Data Validation is not registered as a formula, so is there any way to show a drop-down list only if another cell has a specific value?
ETA: My main objective is to have B2 be absolutely empty if A2 is also empty (or equal to 0). This means I don't even want a drop-down arrow to show if A2 is empty or 0, but I do want the arrow to show if A2 is a value different than 0. Is that feasible?
Thanks in advance!