ExcelBanter - adding a drop down list to an If Statement?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - adding a drop down list to an If Statement? (https://www.excelbanter.com/excel-worksheet-functions/71403-adding-drop-down-list-if-statement.html)

robc

adding a drop down list to an If Statement?

How or can I add a drop down list to an if statement. I have added all 50
states to cell A1 as a drop down choice. I want the statement to be if cell
A1 equals Alabama then cell A2 will have a drop down box for the counties in
that state. Is there a way to do this?

Ron Coderre

adding a drop down list to an If Statement?

Visit Debra Dalgleish's website and check out Dependent Lists:

http://www.contextures.com/xlDataVal02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"robc" wrote:

How or can I add a drop down list to an if statement. I have added all 50
states to cell A1 as a drop down choice. I want the statement to be if cell
A1 equals Alabama then cell A2 will have a drop down box for the counties in
that state. Is there a way to do this?

All times are GMT +1. The time now is 01:30 AM.