Data Validation

[Guest]

I was following this link with the concpet of creating a data validation field,
http://www.contextures.com/tiptech.html.

My only problem is that when I create the column name list headings, I don't
want to use letters, I want to use numbers, ex instead of apple, use 89. Is
there a way I can still use the data validation with numbers?

Thank you

 

[Debra Dalgleish]

If you want to create named ranges for dependent data validation, you
could use a word or letter at the start of the name. For example, create
a range named List_89

Then, in the data validation formula in the dependent cell, use:

=INDIRECT("List_" & A5)

where cell A5 contains the 89.