Jul 15 2020 03:39 AM
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...
Jul 15 2020 03:51 AM
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.
Jul 15 2020 05:09 AM
Jul 15 2020 11:29 PM
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..)
Jul 15 2020 11:58 PM
@CoachK i'm trying to do a similar thing except to fill in sales prices as i select a quantity from a dropdown list. let me know if you get an answer!
Jul 16 2020 08:32 AM - edited Jul 16 2020 09:13 AM
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.
Jul 16 2020 08:38 AM
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.