dependent drop down not working for Model A1, A3, M3.

In my list the model number is A1, A3, A4 but when I use the dependent drop down list & select A1 model then drop down list only  show the result of A1 cell, not according the A1 Model.
Permutation-Combination.xlsx
Salim MollahAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Use this as validation formula
=INDEX($A$2:$BZ$73,,MATCH(CD2,$A$1:$BZ$1,0))
See sheet
Permutation-Combination.xlsx
1
 
Martin LissOlder than dirtCommented:
Please attach your workbook. You do that by clicking the 'Attach File' link that you'll find just below the text entry portion of a post like this one. You will then see a 'Choose File' button. Choose your file and then click the blue 'Upload File' button.
1
 
Salim MollahAuthor Commented:
Dear Martin Liss,

File attached & uploaded. I`m realy stuck on this, kindly help me.

BR
Salim Mollah
0
 
Martin LissOlder than dirtCommented:
There's no attachment so it looks like you forgot to press the blue 'Upload File' button.
0
 
Salim MollahAuthor Commented:
Superb! this is now working, thanks a lot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.