thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to apply a data validation list in Cell C2 which should apply if a condition is met. I have input the following formula:
=IF(B2<>"Disallowed","N/A",'Register'!$B$7#)
However rather than yield a result of "N/A" the cell value is showing as an item from the Register. (This is a drop down list that hides already used items).
I am not sure where I am going wrong here. Can anyone assist?
I am trying to apply a data validation list in Cell C2 which should apply if a condition is met. I have input the following formula:
=IF(B2<>"Disallowed","N/A",'Register'!$B$7#)
However rather than yield a result of "N/A" the cell value is showing as an item from the Register. (This is a drop down list that hides already used items).
I am not sure where I am going wrong here. Can anyone assist?