Microsoft Office Forums - View Single Post - Question of data Validation

Thread: Question of data Validation

View Single Post

Old

12-26-2018, 02:22 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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!).

Reply With Quote