Combine IF statement with validation list [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have set up a spreadsheet with a data validation list in cell A1

Option_1
Option_2


If Option_1 is chosen I want cell B1 to return the value "Not applicable"

If Option_2 is chosen I want cell B2 to allow the user to choose from a second drop down list.

I have no problem creating a validation list based on a previous list by using =INDIRECT(A1), but I don't know how to combine this with option 1



2 replies

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
Hi DJS,

What do you mean by "combine this with option 1"?

A1: Contains drop down list.
B1: Contains IF formula to display either "Not applicable" or "".
B2: Contains drop down list based on value in A1.

Could you explain in a different or more detailed way?

Best regards,
Trowa
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
why not have another list with just one value of ""Not applicable" ?