Data Validation With VLOOKUP & Names

[Leslie]

I have created the following names:

myclaimno=Table2[[#This Row],[Claim No]]
allentities==Table_S1019203_CTCOF01_1[#All]
myentities=6
entitylookup=VLOOKUP(myclaimno,allentities,myentities,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.

 

[Max]

.. My source is: =entitylookup
Try change the DV source to: =INDIRECT(entitylookup)
(wrap it with an INDIRECT)

 

[Leslie]

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?

.. My source is: =entitylookup

Try change the DV source to: =INDIRECT(entitylookup)
(wrap it with an INDIRECT)

---

I have created the following names:

myclaimno=Table2[[#This Row],[Claim No]]
allentities==Table_S1019203_CTCOF01_1[#All]
myentities=6
entitylookup=VLOOKUP(myclaimno,allentities,myentities,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.

 

[Max]

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.