Data validation based on user input in adjacent cell

[Damo71]

Hi

On sheet1
I have named ranges "men", "women" and "children"

On sheet 2,
In Cell A1 I input "male", "female" or "minor". In B1 I need the data validation to show the names from the named range "women" if A1 contains "female", and so on,

is this possible?

thanks

 

[My Aswer Is This]

If you define the ranges:

men women children
Then you need to put:
men,women,children

In validationlist in Sheet2 Range("A1")

And put this value in Sheet(2) Range("B1") validation source:

=INDIRECT($A$1)

Why are you trying to make this hard on yourself

Name the ranges the same as the values you want to see in the data validation list.

Otherwise we will need to use vba.

 

[My Aswer Is This]

Other way is to give ranges two names

Give it the name "men" and also give it the name "male"

And the same with the other ranges

You can give a range two different names.

Then put "male", "female" "minor" in Range("A1")