Data Validation With VLOOKUP & Names
 

I have created the following names:

myclaimno=Table2[[#This Row],[Claim No]]
allentities==Table_S1019203_CTCOF01_1[#All]
myentities=6
entitylookup=VLOOKUP(myclaimno,allentities,myentit ies,false)

On my active cell, I am wanting to put data validation. I selected 'data
validation' and selected list. My source is:
=entitylookup

I have check and unchecked 'ignore blank' and I still get the following
message.
'The list source must be a delimited list, or a reference to a single row or
column.'

What else am I doing wrong or not doing at all. Your help is appreciated,
thanks.

Data Validation With VLOOKUP & Names
 

.. My source is: =entitylookup
Try change the DV source to: =INDIRECT(entitylookup)
(wrap it with an INDIRECT)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leslie" wrote:
I have created the following names:

myclaimno=Table2[[#This Row],[Claim No]]
allentities==Table_S1019203_CTCOF01_1[#All]
myentities=6
entitylookup=VLOOKUP(myclaimno,allentities,myentit ies,false)

On my active cell, I am wanting to put data validation. I selected 'data
validation' and selected list. My source is:
=entitylookup

I have check and unchecked 'ignore blank' and I still get the following
message.
'The list source must be a delimited list, or a reference to a single row or
column.'

What else am I doing wrong or not doing at all. Your help is appreciated,
thanks.

Data Validation With VLOOKUP & Names
 

I changed my source to what you suggested, but now I get another message.
"The Source currently evaluates to an error. Do you want to continue?"
The names work great if I don't use the validation. Could it be something
in my Excel settings?

"Max" wrote:

.. My source is: =entitylookup
Try change the DV source to: =INDIRECT(entitylookup)
(wrap it with an INDIRECT)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leslie" wrote:
I have created the following names:

myclaimno=Table2[[#This Row],[Claim No]]
allentities==Table_S1019203_CTCOF01_1[#All]
myentities=6
entitylookup=VLOOKUP(myclaimno,allentities,myentit ies,false)

On my active cell, I am wanting to put data validation. I selected 'data
validation' and selected list. My source is:
=entitylookup

I have check and unchecked 'ignore blank' and I still get the following
message.
'The list source must be a delimited list, or a reference to a single row or
column.'

What else am I doing wrong or not doing at all. Your help is appreciated,
thanks.

Data Validation With VLOOKUP & Names
 

Could it be something in my Excel settings?
I'm not sure. The INDIRECT wrap in the DV should work. But it is presumed
that the text result returned by the vlookup is a defined name referring to
either a single col range or a single row range. Maybe you could try
re-defining your precedent source ranges to ensure that this happens.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leslie" wrote:
I changed my source to what you suggested, but now I get another message.
"The Source currently evaluates to an error. Do you want to continue?"
The names work great if I don't use the validation.