Data Validation with Defined Name

[Sige]

Hi There,

I have a Defined Name:
Sige ={"a";"b";"c";""}


When trying to use this Name in my Data Validation, allowing List,
source: =Sige
I get the message: "The source currently evalutes to an error"....
A funtion as: Index(Sige;2;1) returns me b

Any reaon why the data validation cannot handle this name?

Brgds Sige
-XL97-

 

[Bernie Deitrick]

Sige,

Try naming a four cell range "Sige" and fill it in with your values. That will definitely work.

HTH,
Bernie
MS Excel MVP

 

[Roger Govier]

Hi Sige

If you are trying to do data validation and only wanting an in put of
a,b,c or d then in the Refers to box just use
a,b,c,d
without any = sign in front.
Alternatively, in a set of cells A1:A4 enter a,b,c,d and call it Sige,
then use =Sige in the refers to box.
Note:
the first solution will only allow the lower case entries you typed in.
the second solution will allow upper or lowercase a,b,c,d

 

[Sige]

Hi Bernie, Roger,

I am familiar with your proposals ... I was/ am just surprised that
Data Validation can handle lists where names are : cell-ranges,
formulas,... but no ''constant'' Names!

Bizar.
Thanks, Sige