Need Help in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1523072%22%20slang%3D%22de-DE%22%3ENeed%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523072%22%20slang%3D%22de-DE%22%3E%3CP%3EI'm%20sorry%20for%20my%20stupid%20question%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20creating%20an%20excel%20file%20for%20my%20football%20team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20help%20to%20create%20the%20link%20between%20the%20name%20and%20the%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20choose%20the%20number%201%20i%20need%20the%20name%20related%20to%20this%20number%2C%20if%20i%20choose%20number%202%20etc...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1523072%22%20slang%3D%22de-DE%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-1523094%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729169%22%20target%3D%22_blank%22%3E%40CoachK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20separate%20table%20which%20maps%20numbers%20on%20names%2C%20in%20any%20other%20place%20you%20may%20VLOOKUP%20the%20name%20based%20on%20number%20(or%20INDEX%2FMATCH%2C%20etc).%20Perhaps%20you%20may%20submit%20small%20sample%20file%20to%20be%20more%20concrete.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523252%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523252%22%20slang%3D%22en-US%22%3E%3CBR%20%2F%3EIf%20Nummber%20is%201%20in%20A1%20and%20Player%20name%20in%20B1%20you%20can%20use%20as%20examble%20in%20C1%3CBR%20%2F%3Ethe%20Formula%3A%20%22%20%3DA1%26amp%3B%22%3A%20%22%26amp%3BB1%20%22%20.%3CBR%20%2F%3EThis%20is%20the%20easiest%20solution%20to%20display%20the%20numbers%20and%20players%20in%20a%20cell%20at%20the%20same%20time.%3CBR%20%2F%3EIf%20this%20is%20not%20wanted%20and%20I%20have%20misunderstood%20please%20ignore%20my%20post.%20If%20it%20is%20useful%2C%20I%20am%20happy%20to%20have%20helped%20you.%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-1525619%22%20slang%3D%22de-DE%22%3ERe%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525619%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20have%20a%20look%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20I%20tipe%20in%20case%20A5%20the%20number%201%20i%20need%20that%20in%20case%20B5%20the%20name%20will%20appear%3C%2FP%3E%3CP%3Eon%20the%20right%20side%20i%20made%20the%20table%20M%2BN%205%20(mister%20x%2C%20mister%20y%2C%20etc..)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1525620%22%20slang%3D%22de-DE%22%3ESubject%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525620%22%20slang%3D%22de-DE%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%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ejust%20have%20a%20look%20at%20my%20post%20to%20sergei%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1525663%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729169%22%20target%3D%22_blank%22%3E%40CoachK%3C%2FA%3E%26nbsp%3B%20i'm%20trying%20to%20do%20a%20similar%20thing%20except%20to%20fill%20in%20sales%20prices%20as%20i%20select%20a%20quantity%20from%20a%20dropdown%20list.%20let%20me%20know%20if%20you%20get%20an%20answer!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526817%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729169%22%20target%3D%22_blank%22%3E%40CoachK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFERROR(INDEX(%24K%245%3A%24K%2433%2CMATCH(A5%2C%24M%245%3A%24M%2433%2C0))%20%26amp%3B%20%22%20%22%20%26amp%3B%20INDEX(%24L%245%3A%24L%2433%2CMATCH(A5%2C%24M%245%3A%24M%2433%2C0))%2C%20%22no%20name%22)%0A%0Aor%0A%0A%3DXLOOKUP(A8%2C%24M%245%3A%24M%2433%2C%20%24K%245%3A%24K%2433%20%26amp%3B%20%22%20%22%20%26amp%3B%20%24L%245%3A%24L%2433%2C%20%22no%20name%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ELatest%20is%20preferable%20if%20your%20version%20of%20Excel%20supports%20it.%20Both%20formulas%20are%20in%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526798%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526798%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729169%22%20target%3D%22_blank%22%3E%40CoachK%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20this%20is%20what%20you're%20looking%20for%20in%20cell%20B5%3A%3C%2FP%3E%3CPRE%3E%3DCONCAT(INDEX(%24K%245%3A%24M%2433%2CMATCH(%24A5%2C%24M%245%3A%24M%2433%2C0)%2C1)%2C%22%20%22%2CINDEX(%24K%245%3A%24M%2433%2CMATCH(%24A5%2C%24M%245%3A%24M%2433%2C0)%2C2))%3C%2FPRE%3E%3CP%3E%26nbsp%3BThen%20simply%20drag%20the%20formula%20down%20to%20fill%20the%20rest.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm sorry for my stupid question :).

 

I'm creating an excel file for my football team.

 

i need help to create the link between the name and the number.

 

if i choose the number 1 i need the name related to this number, if i choose number 2 etc...

7 Replies
Highlighted

@CoachK 

If you have separate table which maps numbers on names, in any other place you may VLOOKUP the name based on number (or INDEX/MATCH, etc). Perhaps you may submit small sample file to be more concrete.

Highlighted

If Nummber is 1 in A1 and Player name in B1 you can use as examble in C1
the Formula: " =A1&": "&B1 " .
This is the easiest solution to display the numbers and players in a cell at the same time.
If this is not wanted and I have misunderstood please ignore my post. If it is useful, I am happy to have helped you.

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

@Sergei Baklan 

 

just have a look

 

if I tipe in case A5 the number 1 i need that in case B5 the name will appear

on the right side i made the table M+N 5 (mister x, mister y, etc..)

Highlighted

@Nikolino 

 

just have a look at my post to sergei

Highlighted

@CoachK  i'm trying to do a similar thing except to fill in sales prices as i select a quantity from a dropdown list. let me know if you get an answer!

Highlighted

Hello @CoachK,

 

Perhaps this is what you're looking for in cell B5:

=CONCAT(INDEX($K$5:$M$33,MATCH($A5,$M$5:$M$33,0),1)," ",INDEX($K$5:$M$33,MATCH($A5,$M$5:$M$33,0),2))

 Then simply drag the formula down to fill the rest.

Highlighted

@CoachK 

That could be

=IFERROR(INDEX($K$5:$K$33,MATCH(A5,$M$5:$M$33,0)) & " " & INDEX($L$5:$L$33,MATCH(A5,$M$5:$M$33,0)), "no name")

or

=XLOOKUP(A8,$M$5:$M$33, $K$5:$K$33 & " " & $L$5:$L$33, "no name")

Latest is preferable if your version of Excel supports it. Both formulas are in attached file.