Use or not use a dropdown list depending on another cell value

[JCMus]

I would like to use or not use a dropdown list in data validation depending on the value of another cell. The application is to be able to choose a state from the dropdown list only if the country selected in another cell is "US". If the country is not US then I want the user to be able to fill in free text and there be no dropdown list. I know it's possible to have a dropdown list and allow entries without it being on the list but I need the dropdown list not to appear at all if the value is not US. Can someone help please?

Thanks,
Joe M

[JBeaucaire]

What is the current settings for that data validation drop down? Specifically the SOURCE: ?

[xlman]

Hi JCMus,

Type a list of US States in a column and save the range as a Name say "US States".

Let's say you enter "US" in cell A1. You need a drop down in B1.

Select cell B1, click on Data tab, select "Data Validation" option & use the below given formula in "Source" filed
=if(A1="US","US States."")
Remember to select "List" in "Allow" filed of "Settings" tab and clear the check box in "Error Alert" tab of "Data Validation"

You will see a dropdown list when cell A1 value is "US"
You will not get any list when cell A1 value is other than "US". You can manually enter any data in B1 now.

Hope that works for you.

Regards,
xlsman

[lancer102rus]

xlman, did you try to do your operations by yourself?

[lancer102rus]

JCMus, check this
list.xlsm

[xlman]

Yes. I did.

Check the attachment.

[lancer102rus]

xlman, OK, but did you read TS topic?

...I know it's possible to have a dropdown list and allow entries without it being on the list but I need the dropdown list not to appear at all if the value is not US.

[xlman]

Yes. You may see drop down arrow, but won't get any list of states and still you can type data in that cell.

I presumed that drop down is in a particular cell.
That's what i understood.

But, may be your assumption is correct, if the result cells are different.

Thanks for communicating.

Regards,
xlman