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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 15, 2020

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.

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