Excel 'IF' formula with a DropDown value

February 4, 2011 at 12:00:56
Specs: Windows 7
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($E$11='Sheet2'!C14,'Sheet2'!B245," ")

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!!

See More: Excel IF formula with a DropDown value

Report •

February 4, 2011 at 12:18:49
As a followup, I found the field changes depending on the drop down value selected. 1 for blank, 2 for <500K and 3 for >500K. Once I changed the logical_test to show this, it worked. I guess I just needed to type it out to make me look at it closer!!

Report •

February 4, 2011 at 13:17:42
You should be aware that the formula you used will not produce a "blank" cell.

" " is a space.

"" is a null string.

Those are 2 very different things.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question