IF formula based on Data Validation choice

Question

I have a Data Validation list with only two choices, and I want to drive the contents of another cell with an IF formula based on the Data Validation choice. In other words, I want something like this:

If A1 = "Option 1" from dropdown list, write "True" in B1; if A1 = "Option 2" from dropdown, write "False" in B1.

So my formula should be something like: If(A1="Option1), "True", "False")

But it's not working. It's giving me the 'value_if_false' condition ("False") whether A1 is "Option 1' or "Option 2". It's like it's not recognizing the test value from the Data Validation List correctly. 

I thought maybe an Indirect reference would help; but I can't seem to get that to work either. Any ideas?

Thanks!

JohnnyMac

Answer 1

You could use

=A1="Option1"

If that doesn't work, check carefully that you have spelled the option exactly the same way as it is in the source of the validation dropdown. For example, check for "Option1" vs "Option 1" or "Option1 " (note the space after the 1 in the latter).