Dependent drop-down list with if conditions

**saleemp5678** · 05-30-2017, 08:21 AM

Hi,

I have a problem with the dependent dropdown list.
For eg, if the value of cell A1<5; then cell B1 should have a drop-down list of 'Names". And if cell A1>5; then cell B1 should have a drop-down list of "Departments".

I would like to know how to do this...

Thanks,

Saleem.

**shukla.ankur281190** · 05-30-2017, 08:28 AM

Assume you have Name list in H & Dept in I column

F1

Formula:

Please Login or Register  to view this content.

In Drop down

put

Formula:

Please Login or Register  to view this content.

then ok

Look at the attached file.

**JohnTopley** · 05-30-2017, 08:31 AM

Create named ranges called "Names" and "Departments"

in Data Validation

Allow: List
source: =IF(A1<=5,Names,Departments)

Check test is "<=" or">="

Dependent drop-down list with if conditions

LinkBack

Thread Tools

Rate This Thread

Display

Dependent drop-down list with if conditions

Re: Dependent drop-down list with if conditions

Re: Dependent drop-down list with if conditions

Thread Information

Users Browsing this Thread

Similar Threads

Dependent drop down in excel table 2 conditions

[SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list

Dependent Drop Down list to autofill next drop down with selective choices

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE

[SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list

[SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions