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