Jennifer_Reynolds
New Member
- Joined
- Jul 8, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
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!
=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!