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.