you can't vlookup a whole column, only one cell at a time

"mico" wrote:

Why is this a valid statement as a validation source
=INDIRECT(VLOOKUP(A2,CenterCodeDesc,2,FALSE))
but this is not
=INDIRECT(VLOOKUP(A:A,CenterCodeDesc,2,FALSE))

How do I create a validation source using column A for Vlookup?

Thanks