#1
|
|||
|
|||
Question of data Validation
Hello
Have a look at the file attached. I used 'Data Validation' to force cell B1 to accept just numbers 1 or 2 (if A1 be equal to the word "Iamgood"). If the word "Iamgood" (in cell A1) changes to "I am good", then it does not work. It seems spaced between characters make problem for it? Let me know your ideas. Thanks a lot. |
#2
|
|||
|
|||
You have defined (as defined name) iamgood, referring to E1:E2. And in your Data Validation you refer indirectly to iamgood (in A1) so of course if you change A1 to I am good then =INDIRECT($A$1) returns an error (#REF!).
|
#3
|
|||
|
|||
xor
The problem is Data Validation does not accept Spaces between words as defined name and the error appears. Have a look at photos below and open the file again and try to change the defined name to "I am good" and see what happens. |
#4
|
|||
|
|||
Then what about using
=INDIRECT(SUBSTITUTE($A$1," ","")) in Data Validation? |
#5
|
|||
|
|||
It done. Thank you very much.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Validation - List | Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
Paste over data validation | saurabhlotankar | Excel Programming | 2 | 05-24-2015 11:52 PM |
data validation from another sheet | paulys | Excel | 1 | 06-30-2014 01:40 AM |
Data Validation drop down | rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |