Validation based on a range of values

[daddioja]

I am trying to figure out how to validate the entry into a cell based on a list located in the worksheet. For example. I have a list of names, and the user should enter one of those names in Cell A3. The only problem is that the list of names changes. So I can't write the validation to reference the specific names. I hope I can have the validation reference the range that contains the names and makes sure that the entry is one of those names.

Does anyone knwo if this is possible, and hopefully how to do it? Thanks for any help you can provide.

[Avner]

hi
give your range of names a dinamic_range_name and on data validation choose the list and for reference give that dinamic range name.
Avner

[Carim]

Hi,

Just give a name to your reference list
(with Insert Name Define)

then in the Data Validation
Select List
and in the Source area, type
=NameOfList

do not forget the sign = ...

HTH
Carim

[daddioja]

Thanks Avner. Can you explain that a bit more?

[Carim]

You can define a range with a "dynamic range" i.e a range which adjusts itself automatically ...

Insert Name Define
give your range a name
in the formula area type
=Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))

HTH
Carim

[Avner]

You can define a range with a "dynamic range" i.e a range which adjusts itself automatically ...

Insert Name Define
give your range a name
in the formula area type
=Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))

HTH
Carim

that is to say that the list starts in A1.
If the list of names is 1 column, the CountA(Sheet1!$1:$1) is replaced with 1

avner

[daddioja]

Thanks guys. I got it. That works great!

[Carim]

Glad your problem is fixed

Thanks for the feedback

Carim