Combine IF statement with validation list Closed

Question

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



Configuration: Windows XP / Safari 535.1

TrowaD · Answer

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

rizvisa1 · Answer

why not have another list with just one value of ""Not applicable" ?

Combine IF statement with validation list

2 responses

Similar discussions

Subscribe To Our Newsletter!