How do i merge two lists in excel, to sort out information

%3CLINGO-SUB%20id%3D%22lingo-sub-1939985%22%20slang%3D%22en-US%22%3EHow%20do%20i%20merge%20two%20lists%20in%20excel%2C%20to%20sort%20out%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939985%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20lists%20of%20information%2C%20and%20I%20want%20to%20be%20able%20to%20choose%20something%20from%20the%20first%20list%2C%20and%20then%20the%20other%20list%20will%20sort%20out%20what%20information%20goes%20under%20this%20subjekt.%20Lets%20say%20list%20nr.%202%20has%20100%20different%20informations%20and%20can%20be%20sorted%20out%20in%205%20kategoriens%2C%20when%20i%20choose%20one%20of%20those%205%20kategories%20in%20list%20nr.%201%20i%20will%20only%20have%2020%20things%20to%20choose%20by%20next%20instead%20of%20100.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1939985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940002%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20do%20i%20merge%20two%20lists%20in%20excel%2C%20to%20sort%20out%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940002%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885502%22%20target%3D%22_blank%22%3E%40Signeestrup%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20not%20to%20be%20misunderstood%2C%20in%20the%20community%20it%20is%20the%20aim%20of%20excel%20users%20to%20give%20help%20on%20their%20project%20(from%20Excel%20users)%2C%20or%20rather%2C%20to%20provide%20food%20for%20thought%20and%20not%20to%20deliver%20finished%20work%20or%20finished%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940046%22%20slang%3D%22en-US%22%3EBetreff%3A%20How%20do%20i%20merge%20two%20lists%20in%20excel%2C%20to%20sort%20out%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BThank%20you!%20I've%20uploaded%20a%20test%20sheet%20now%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have two lists of information, and I want to be able to choose something from the first list, and then the other list will sort out what information goes under this subjekt. Lets say list nr. 2 has 100 different informations and can be sorted out in 5 kategoriens, when i choose one of those 5 kategories in list nr. 1 i will only have 20 things to choose by next instead of 100. 

Thank you in advance

 

I've added a test sheet now for more clear explanation. When I choose ''Pets'', I only wat Dog, Cat and Horse to be in list nr. 2 and so on

3 Replies

@Signeestrup 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the Excel version and operating system would also be an advantage.

 

In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino Thank you! I've uploaded a test sheet now 

@Signeestrup 

 

In the spirit of what @Nikolino wrote,

in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

I'm attaching an example of a way to accomplish your goal.