Combine IF statement with validation list

Closed
DJS - Aug 17, 2011 at 08:10 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2011 at 06:00 PM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 18, 2011 at 10:15 AM
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
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 18, 2011 at 06:00 PM
why not have another list with just one value of ""Not applicable" ?
0