How to look up using dropdown

%3CLINGO-SUB%20id%3D%22lingo-sub-2281595%22%20slang%3D%22en-US%22%3EHow%20to%20look%20up%20using%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20help%20please.%26nbsp%3B%20Let's%20say%20I%20have%20many%20cols%20with%20rows%20of%20data%20such%20as%20this%3A%3C%2FP%3E%3CP%3EName------Swimming------Running-----Basketball----Baseball-----Football-----Soccer%3C%2FP%3E%3CP%3EJoe%20D.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bx%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bx%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20x%3C%2FP%3E%3CP%3EJanet%20T.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20x%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20x%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EHelgar%20M.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20x%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20x%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20to%20build%20a%20dropdown%20list%20that%20based%20on%20the%20dropdown%20list%20a%20user%20select%2C%20it%20returns%20the%20name%20of%20the%20sport%20that%20the%20individual%20participated%20in.%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282878%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20look%20up%20using%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282878%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1026096%22%20target%3D%22_blank%22%3E%40TB_VN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20a%20sample%20file.%26nbsp%3B%20Due%20to%20sensitivity%2C%20I%20can't%20send%20the%20actual%20file.%3C%2FP%3E%3CP%3EIn%20the%20first%20column%20(Col%20A)%20is%20the%20current%20data%2C%20and%20under%20each%20of%20the%20Sport%20there%20are%20many%20players'%20name%20that%20I%20can't%20list%20them%20all.%26nbsp%3B%20Under%20some%20of%20the%20Sport%20title%2C%20there%20could%20be%20from%2010%20-%20200%2B%20players'%20name%20depends%20on%20the%20Sport%20title.%3C%2FP%3E%3CP%3EOn%20the%20Expected%20Output%3A%26nbsp%3B%20that's%20where%20I'd%20like%20to%20see%20the%20output%20to%20display%20in%20cols.%26nbsp%3B%20There%20are%20many%20more%20Sport%20Names%2C%20not%20limited%20to%20the%20list%20in%20the%20file.%26nbsp%3B%20So%2C%20if%20there's%20a%20way%20to%20read%20in%20Sport%20title%2Fname%20and%20its%20players'%20names%2C%20then%20continues%20to%20the%20next%20col%20etc...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps%20clear%20the%20ambiguity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282750%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20look%20up%20using%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282750%22%20slang%3D%22en-US%22%3EForgive%20me%2C%20but%20I%20am%20not%20making%20my%20life%20more%20difficult%20than%20it%20already%20is.%3CBR%20%2F%3EWhat%20is%20preventing%20you%20from%20inserting%20this%20data%20in%20the%20photos%20into%20a%20new%20file%20(where%20there%20are%20no%20sensitive%20data)%20and%20including%20this%20file%20in%20your%20declaration%3F%3CBR%20%2F%3EWhy%20do%20I%20have%20to%20write%20down%20everything%20individually%20from%20the%20photos%20and%20make%20a%20file%20for%20you%20myself%3F%3CBR%20%2F%3EWhere%20is%20the%20problem%20to%20announce%20his%20Excel%20version%20and%20his%20operating%20system%20version%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20you%20continue%20to%20enjoy%20Excel%2C%20I'm%20out%20of%20line.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282588%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20look%20up%20using%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282588%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%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply%2C%20I'll%20try%20to%20see%20if%20I%20can%20post%20pics%20on%20here.%3C%2FP%3E%3CP%3EThe%20first%20one%20is%20my%20text%20file%2C%20it%20contains%20(capture1%20file)%20and%20my%20expected%20results%20(capture2%20file).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281690%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20look%20up%20using%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1026096%22%20target%3D%22_blank%22%3E%40TB_VN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EPlease%20read%20it%20through!%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EForgive%20me%20from%20the%20start%2C%20but%20always%20the%20same%20...%20it's%20not%20pretty.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EEveryone%20has%20a%20problem%20...%20I%20can%20understand.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAnyone%20looking%20for%20help%20here%20is%20sure%20that%20their%20problem%20is%20very%20important%20to%20them%20...%20I%20can%20understand.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20I%20can't%20understand%20that%20everyone%20just%20writes%20on%20it%20without%20a%20file%20or%2C%20in%20the%20best%20case%2C%20inserts%20a%20picture%20and%20means%20that%20everyone%20goes%20to%20the%20trouble%20of%20creating%20files%20and%20other%20descriptions%20for%20them%20by%20the%20others%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETherefore%2C%20I%20ask%20you%20to%20read%20the%20link%20carefully%20in%20advance.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-link-navigation%20lia-link-disabled%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20understanding%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I need some help please.  Let's say I have many cols with rows of data such as this:

Name------Swimming------Running-----Basketball----Baseball-----Football-----Soccer

Joe D.               x                                             x                                                          x

Janet T.                                    x                                            x          

Helgar M.                                                        x                                        x

 

I need help to build a dropdown list that based on the dropdown list a user select, it returns the name of the sport that the individual participated in.

Please help!

4 Replies

@TB_VN 

Welcome to your Excel discussion space!

Please read it through!

 

Forgive me from the start, but always the same ... it's not pretty.

Everyone has a problem ... I can understand.

Anyone looking for help here is sure that their problem is very important to them ... I can understand. But I can't understand that everyone just writes on it without a file or, in the best case, inserts a picture and means that everyone goes to the trouble of creating files and other descriptions for them by the others.

Therefore, I ask you to read the link carefully in advance.

 

Thank you for your patience and understanding

 

Nikolino

@NikolinoDE 

Thanks for the reply, I'll try to see if I can post pics on here.

The first one is my text file, it contains (capture1 file) and my expected results (capture2 file).

 

Forgive me, but I am not making my life more difficult than it already is.
What is preventing you from inserting this data in the photos into a new file (where there are no sensitive data) and including this file in your declaration?
Why do I have to write down everything individually from the photos and make a file for you myself?
Where is the problem to announce his Excel version and his operating system version?

I hope you continue to enjoy Excel, I'm out of line.

Thank you for your understanding


Nikolino
I know I don't know anything (Socrates)

@TB_VN 

 

Attached is a sample file.  Due to sensitivity, I can't send the actual file.

In the first column (Col A) is the current data, and under each of the Sport there are many players' name that I can't list them all.  Under some of the Sport title, there could be from 10 - 200+ players' name depends on the Sport title.

On the Expected Output:  that's where I'd like to see the output to display in cols.  There are many more Sport Names, not limited to the list in the file.  So, if there's a way to read in Sport title/name and its players' names, then continues to the next col etc...

 

I hope this helps clear the ambiguity.

 

Thanks in advance,