Forum Discussion
Need Help in excel
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
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)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.
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.
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..)
