Data Validation when a list is already in place

A

Alex

I want to be able to allow an option on a drop down list only if another cell
has a particular value.

What I am trying to do is I have a list of people with their title
(Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a
dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows
an entry of Female to gender, and if Mr is selected it only allows Male for
Gender.

Is there any way to do this?

Cheers
 
B

Bob Phillips

Us a custom type in the DV with a formula of

=IF(OR(H1="Ms",H1="Miss",H1="Mrs"),"Female","Male")

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
R

Roger Govier

Hi Bob

I don't think that will work
I think the Op will need to set up 2 cells, one with M and one with F (I
used K1 and K2)
and use DV with List and enter the following into the List source
=IF(A1="Mr",$K$1,$K$2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top