Forum Discussion

CoachK's avatar
CoachK
Copper Contributor
Jul 15, 2020

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...
excel
Formulas and Functions
CoachK's avatar
CoachK
Copper Contributor
Jul 16, 2020

SergeiBaklan 

 

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

PReagan's avatar
PReagan
Bronze Contributor
Jul 16, 2020

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.

Resources