Hello, I would really appreciate some help with the following. I created 2 dependent drop lists in cells E8 and F8. For some reason the drop down list for my cities won't work unless I manually type in the state name in cell E8. Perhaps it's the Offset statement used in cell E8 and F8 that somehow conflict with each other? Here's the formulas I used in the source validation boxes for cell E8 and F8.
E8- OFFSET(CountryStart,MATCH($D8,CountryColumn,0)-1,1,COUNTIF(CountryColumn,$D8),1)
E9-
=OFFSET(RegionStart,MATCH($E8,RegionColumn,0)-1,1,COUNTIF(RegionColumn,$E8),1)
E8- OFFSET(CountryStart,MATCH($D8,CountryColumn,0)-1,1,COUNTIF(CountryColumn,$D8),1)
E9-
=OFFSET(RegionStart,MATCH($E8,RegionColumn,0)-1,1,COUNTIF(RegionColumn,$E8),1)
| Excel Workbook | |||||
|---|---|---|---|---|---|
| D | E | F | |||
| 7 | Pays/ Country | Province / State | Ville / City | ||
| 8 | UNITED STATES | CA | Select City | ||
| 9 | Select City | ||||
| 10 | Select City | ||||
| 11 | Select City | ||||
Sheet | |||||
