How can I do in data validation?

[MG]

Hi,
I have a question about list name in Data Validation.

For example, I have two columns A & B. I want to use Data Validation on
column B with 'List'. Normally, I just input '=ListName' in 'Source' box. My
question is, the list name is the value in column A. How can I input in
'Source' box then?

Thanks!
MG

 

[Roger Govier]

Hi

Insert>Name>Define> Name ListName Refers To =$A$1:$A$100
Make the refer to range match the range of cells where you have values in
column A

 

[geoff_ness]

If the cell A1 contains the name of a range you wish to use as a list
to validate in B1, then try entering
=INDIRECT(A1)
into the source box for validation in B1.

HTH

 

[MG]

Great! That's what I want. Thank you!

MG

If the cell A1 contains the name of a range you wish to use as a list
to validate in B1, then try entering
=INDIRECT(A1)
into the source box for validation in B1.

HTH