|
|
|
|
#1
12-26-2018, 02:22 AM
|
|||
|
|||
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!). 
|
|
|
|
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 |
Windows 10 
Office 2016
Hybrid Mode