If/Or statement not working when incorporating result of a drop down list

[Jennifer_Reynolds]

Hi everyone, I have the below formula which is designed to return a blank in a Worksheet2 cell if there is no value in Worksheet 1 cell A11 or if Worksheet 1 cell E11 value is 'Targeted'. If neither of these conditions are met, the formula should return the value in Worksheet1 cell A11

=IF(OR('Worksheet1 '!A11="", 'Worksheet1 '!E11="Targeted"), " ", 'Worksheet1 '!A11)

Problem is that column E is a drop down list and it doesn't seem to work - the above formula does work if I for example use text from another column as part of the or statement but then doesn't seem to work for column E with the drop downs. Is there an issue with incorporating drop down lists that requires an alternative approach/solution?

Thank you!

 

[Joe4]

Welcome to the Board!

No, it shouldn't be an issue if the value comes from a drop-down or from hard-coded text.
Usually, the culprit is an extra space somewhere in the value of your drop-down list.

When E11 is selected to be "Targeted", try entering this formula in any blank cell on "Worksheet1 ":
=LEN(E11)

If it returns anything more than 8, then you have some extra spaces in there.

 

[Jennifer_Reynolds]

Welcome to the Board!

No, it shouldn't be an issue if the value comes from a drop-down or from hard-coded text.
Usually, the culprit is an extra space somewhere in the value of your drop-down list.

When E11 is selected to be "Targeted", try entering this formula in any blank cell on "Worksheet1 ":
=LEN(E11)

If it returns anything more than 8, then you have some extra spaces in there.

Thanks, easy when you know how. Yes that was the issue, 9 characters rather than 8. Problem solved, thank you.

 

[Joe4]

You are welcome.
Glad I was able to help!