Forum Discussion
CelineFoong
May 24, 2021Copper Contributor
How can i create 3 dependent drop down list with the 3rd drop down depending on 1st and 2nd list?
Here is my list of data. For Dropdown3, I will want the dropdown to be dependent on BOTH Dropdown1 and Dropdown2. Kindly note that some of the values within Order Information/Shipping Information und...
- May 24, 2021
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)
ChristianDeinzer
Apr 06, 2022Copper Contributor
Thanks for your help and reply.
I am looking not to use VBA.
Please have a look on the file and see if you can help me.
https://1drv.ms/x/s!AtcEIJC2JdswgzXG9djJJgczPkYX?e=7slZzb
Thanks!!
HansVogelaar
Apr 06, 2022MVP
Unfortunately, we cannot use functions such as SORT or UNIQUE directly in data validation. I don't see a solution without using VBA.
- ChristianDeinzerApr 06, 2022Copper ContributorNo problem!
Thanks again!