Forum Discussion
How can i create 3 dependent drop down list with the 3rd drop down depending on 1st and 2nd list?
See the attached sample workbook.
Select C2 on the Data Entry sheet and click Data Validation on the Data tab of the ribbon to see the formula I used. It is
=OFFSET(Lists!$C$1,MATCH(1,(Lists!$A$2:$A$27=A2)*(Lists!$B$2:$B$27=B2),0),0,COUNTIFS(Lists!$A$2:$A$27,A2,Lists!$B$2:$B$27,B2),1)
See the attached sample workbook.
Select C2 on the Data Entry sheet and click Data Validation on the Data tab of the ribbon to see the formula I used. It is
=OFFSET(Lists!$C$1,MATCH(1,(Lists!$A$2:$A$27=A2)*(Lists!$B$2:$B$27=B2),0),0,COUNTIFS(Lists!$A$2:$A$27,A2,Lists!$B$2:$B$27,B2),1)
It looks like it is exactly I have been looking for, but for some reason your Dropdown3 is not working.
Could you please let me know how to fix it?
Thanks a lot!
It looks like data validation has to be refreshed when the workbook is opened.
The attached new version is now a macro-enabled workbook; you may have to allow macros when you open it. I hope this works for you.
How do I make Drop down 2 dependant on the selection of Drop down 1 and Drop down 3 dependant on the selections of both?
Thank you in advance
Appreciate your great help and reply.
I tried at my end using the formula you provided and it works 🙂
Thank you for the great help , this formula really save alot of time in my work
Happy Weekend
Celine
