How can I do in data validation?

  • Thread starter Thread starter MG
  • Start date Start date
M

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
 
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
 
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
 
Great! That's what I want. Thank you!

MG


geoff_ness said:
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
Click to expand...
 
Back
Top