Skip to main content
Web Applications

Return to Question

Became Hot Network Question
added 258 characters in body
Source Link
Nathan96
Nathan96
  • 31
  • 1
  • 3

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!

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?

Thanks in advance!

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!

Source Link
Nathan96
Nathan96
  • 31
  • 1
  • 3

Can I have a drop-down list appear in a cell only if another cell contains a specific value?

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?

Thanks in advance!