Excel If statement & Data Validation

February 21, 2011 at 09:00:34
Specs: Windows XP
I am trying to crete a form with a drop down list to select the following: So if cell A1 says "Alcohol" then in cell B1 show a drop down list of the Countries that ship Alcohol. If selected A1Biological Substance then B1 show a drop down list to show at all countries that ship biological substance, and if A1 says Frozen Fish then b1 shows all countries related to Frozen Fish and so on. Can anyone help?

See More: Excel If statement & Data Validation

Report •

February 22, 2011 at 09:59:18
So A1 could be Alcohol, Biological Substance, or Frozen Fish, and you need the drop down list to change depending on what is entered in A1?

If A1 was always Alcohol, it would be easy to make a dropdown list of countries that ship Alcohol.

If you need this list to be dependent on the value in A1, then you need a dependent list. This should give you everything you need. http://www.contextures.com/xlDataVa...

Report •
Related Solutions

Ask Question