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 n...
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.
