Using a named range in Data Validation list

[jimbojr]

Friends,

I'm hoping there's a simple (non VBA) solution to this question. I want to use a named range of value as the lookup list for Data Validation. The range is on the same sheet as the cell I want to validate.

It appears, however, that any lists reference the lookup values by absolute cell references.

Can I use the values in my named range as my validation list?

Jimbo

 

[Zack Barresse]

yes, i actually prefer a named range for data validation -> list.

"=ListName"

should work.

hope this helps.

 

[SIXTH SENSE]

hi!
on the validation list on the allow field choose "list"
then on the data field enter
=myrangename
then you have your validation list.

is this what you mean?

 

[Zack Barresse]

Data -> Validation -> Allow -> List

in the source box type:

=ListName

just remember when you name your list, that if you want there to be a blank entry, include that in your list name.

 

[jimbojr]

Re: Using a named range in Data Validation list - SOLVED

Thanks to all who responded.

You solution is what I tried the first time (seemed intuitive enough). Yet, instead of getting the list of values in the range in my validation drop-down, I got the range name itself.

I must have screwed up my formula, as simple as it was, somehow.

It works just fine!

Thanks again!

Jimbo

 

[RobertWaters]

Re: Using a named range in Data Validation list - SOLVED

Thanks to all who responded.

You solution is what I tried the first time (seemed intuitive enough). Yet, instead of getting the list of values in the range in my validation drop-down, I got the range name itself.

I must have screwed up my formula, as simple as it was, somehow.

It works just fine!

Thanks again!

Jimbo

It's all to do with the quotes. If you use

"=NamedRange"​

then the dropdown will display

NamedRange​

but if you use

=NamedRange​

then the dropdown will display the values in the named range