|I have a drop down list with 2 possible answers. I am trying to create an IF formula that will populate a field if the value selected from the drop down is the one value and blank if the other value. I've used IF logic before with no problems but I think because its a drop down, it is not pulling the correct value. This is what I have:|
if I right click on the drop down, the Name Box says 'Drop Down 40' and the function box shows =$E$11. I entered the logical_test as $e$11= and then pointed it to the value I wanted selected from the drop down that was on a separate sheet. This made the Logical value = False. Then for the value_if_true, I selected the field on the 2nd sheet that has the text I want to populate. Leaving the Value_if_false with spaces. The produces a blank line, regardless of which option is selected in the drop down. I changed the value_if_true and the value_if_false around and the results are that the text always shows, regardless of what is selected from the drop down.
I've checked the different Data features but do not see anything that address this particular need. Any help or suggestions would be greatly appreciated!!