SOLVED

Regarding Dependent drop down menu for a matrix in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2371681%22%20slang%3D%22en-US%22%3ERegarding%20Dependent%20drop%20down%20menu%20for%20a%20matrix%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2371681%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%20%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20immediate%20help%20.%20Can%20anyone%20please%20help%20me%20.%20I%20am%20trying%20to%20make%20dependent%20drop%20down%20menu%20for%20a%20matrix%20which%20has%20to%20placed%20in%20worksheet%26nbsp%3B%20but%20even%20after%20trying%20so%20many%20times%20i%20am%20unable%20to%20do%20it%20.%20I%20have%20attached%20the%20picture%20and%20excel%20file%20of%20same%20.%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2371681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2372238%22%20slang%3D%22en-US%22%3ERe%3A%20Regarding%20Dependent%20drop%20down%20menu%20for%20a%20matrix%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2372238%22%20slang%3D%22en-US%22%3EIt's%20not%20clear%20what%20the%20drop%20downs%20should%20be.%3CBR%20%2F%3E%3CBR%20%2F%3EMay%20I%20ask%20a%20question%3A%20this%20looks%20like%20it%20could%20be%20a%20school%20assignment%20of%20some%20kind%2C%20is%20it%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20it%20is%2C%20we'd%20be%20doing%20your%20homework%20for%20you.%20I%20have%20an%20example%20I've%20built%20of%20dependent%20drop%20downs...in%20fact%20if%20you%20search%20this%20website%20you%20could%20probably%20find%20some--which%20would%20be%20just%20fine.%20You'd%20still%20have%20to%20adapt%20the%20method%20to%20your%20own...%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20it's%20not%20the%20case%2C%20then%20let%20us%20know%20and%20I'll%20post%20my%20example%20sheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2372301%22%20slang%3D%22en-US%22%3ERe%3A%20Regarding%20Dependent%20drop%20down%20menu%20for%20a%20matrix%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2372301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1058814%22%20target%3D%22_blank%22%3E%40Sabya007%3C%2FA%3E%26nbsp%3BThe%20data%20validation%20list%20refers%20to%20%3CSTRONG%3E%3D'%5BAL-rev3.xlsx%5DMaster%20Data'!%23REF!%3C%2FSTRONG%3E.%20%26nbsp%3BWithout%20the%20%22AL-rev3.xlsx%22%20file%20it%20cannot%20be%20determined%20what's%20wrong.%3C%2FP%3E%3CP%3EIf%20you%20are%20trying%20to%20refer%20to%20the%20scenarios%20on%20the%20Master%20Sheet%20in%20the%20workbook%20you%20uploaded%2C%20note%20that%20you%20have%20quite%20a%20few%20empty%20rows%20in%20that%20range.%20But%20then%20it%20could%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D'Master%20Sheet'!%24F%245%3A%24F%2421%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2373938%22%20slang%3D%22en-US%22%3ERe%3A%20Regarding%20Dependent%20drop%20down%20menu%20for%20a%20matrix%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2373938%22%20slang%3D%22en-US%22%3EThank%20you%2C%3CBR%20%2F%3EI%20cannot%20post%20the%20sheet%20here%20due%20to%20company%20restrictions%20.%20Basically%20what%20i%20am%20trying%20is%20%2Cif%20someone%20selected%20%22Custom_duties_for_incoming_goods%20%22%20under%20Scenario%20he%20just%20have%20only%20one%20option%20%22306000%20-%20Freight%20costs%22%20under%20%22ledger%20account%20%22%20and%20if%20he%20selected%20%22Assembly%20%22%20he%20have%20options%20under%20%22Product%20Group%20%22.%20Is%20that%20possible%20via%20Dependent%20drop%20down%20%3F%3CBR%20%2F%3ERegards%3C%2FLINGO-BODY%3E
New Contributor

Hi Community , 

I need your immediate help . Can anyone please help me . I am trying to make dependent drop down menu for a matrix which has to placed in worksheet  but even after trying so many times i am unable to do it . I have attached the picture and excel file of same . 

Regards

5 Replies
It's not clear what the drop downs should be.

May I ask a question: this looks like it could be a school assignment of some kind, is it?

If it is, we'd be doing your homework for you. I have an example I've built of dependent drop downs...in fact if you search this website you could probably find some--which would be just fine. You'd still have to adapt the method to your own...

If it's not the case, then let us know and I'll post my example sheet.
best response confirmed by Sabya007 (New Contributor)
Solution

@Sabya007 The data validation list refers to ='[AL-rev3.xlsx]Master Data'!#REF!.  Without the "AL-rev3.xlsx" file it cannot be determined what's wrong.

If you are trying to refer to the scenarios on the Master Sheet in the workbook you uploaded, note that you have quite a few empty rows in that range. But then it could look like this:

='Master Sheet'!$F$5:$F$21

Dear Sir ,
I am employee to a company . I am having hard time solving this . This is cut and paste from report sheet , which I can't post here . I was doing this to reduce the error , which occurs due to wrong entry by suppliers.
Thank you.
Thank you,
I cannot post the sheet here due to company restrictions . Basically what i am trying is ,if someone selected "Custom_duties_for_incoming_goods " under Scenario he just have only one option "306000 - Freight costs" under "ledger account " and if he selected "Assembly " he have options under "Product Group ". Is that possible via Dependent drop down ?
Regards

@Sabya007 

 

Here's a demo sheet I created a few months ago that shows how dependent drop downs can be created and used. Perhaps it will help. It's definitely possible.