how to change a number to name

G

Guest

I have a bowling league schedule that looks like this:
Lanes 1 2 3 4 5 6 7 8 9
Teams1-2 3-4 5-6 7-8 9-10 11-12 13-14 15-16 17-18
The top numbers represent lanes or alley numbers, and the
second row of figures represent the team members.The team
members numbers represent a name from a list. For this
question the names on the list are a,b,c,d,etc through r
(18 total) I would like to have formula that I could
change the team members numbers to team members names,
i.e,; 1=a, 2=b, 3=c, etc all the way through the number
18 and letter r. I cannot write the formula, I need
someone to give me a details of how to do it. Thanks, WAB
 
F

Fredrik Wahlgren

I have a bowling league schedule that looks like this:
Lanes 1 2 3 4 5 6 7 8 9
Teams1-2 3-4 5-6 7-8 9-10 11-12 13-14 15-16 17-18
The top numbers represent lanes or alley numbers, and the
second row of figures represent the team members.The team
members numbers represent a name from a list. For this
question the names on the list are a,b,c,d,etc through r
(18 total) I would like to have formula that I could
change the team members numbers to team members names,
i.e,; 1=a, 2=b, 3=c, etc all the way through the number
18 and letter r. I cannot write the formula, I need
someone to give me a details of how to do it. Thanks, WAB

Assuming the number 1 is in A1, use =CHAR(A1+96) to get an "a". If you pass
2, it will return "b".

/Fredrik
 
G

Guest

Thanks, I have the names numbered in a A and the names in
column B. But I don't know how to do the VLOOKUP formula.
 
G

Guest

That doesn't seem to do it. A further explanation is;
The names of the people are not really "a", "b", etc,
they have real names like Robert, Joe, Rose, Jackie,
Glenn, etc. They are listed on sheet 2, in col a there
are numbers 1 through 18 and a name is assigned to each
number in col b. That is, 1 is robert, 2 is Joe, 3 is
Rose, 4 is Jackie, right on down the list. On sheet 1 is
the schedule with the numbers showing who is playing who,
example 1 vs 2 (translated, Robert is playing Joe, 3 vs
4, Rose is playing Jackie. I would like to have a macro
that when I activate the macro it will automatically
change the numbers in the schedule to the names
associated with the number.
 
K

Kassie

Sorry that I took so long to answer, but only got a chance to answer your
post now. Let me get this straight. Are the team numbers in one or two
cells on your schedule. Do you want the names to appear in one cell or two
cells. Do you want to show the names below or beside the numbers, or do you
actually want to replace the entered numbers with names at some stage. If
the latter, you will need a macro, but I need to be sure before I start.
 
W

wally667

Thanks for your response. Max sent me a formula to accomplish what I wanted,
i.e., the numbers are in one cell, want the names to appear in one cell,
actually replace each number with a specified name. Example "2 vs 3" would be
"Joan - Joe"(ignore quotes). Maybe you can help me with another problem. Just
how do I post a new question on this site. I have signed up for MS's
Passport.net and I can read the posts and reply to the posts but I cannot
start a new thread or ask a new question. I have tried to e-mail MS but it's
virtually impossible to find who to go to. I hope you can shed some light on
this. Thanks, wab.
 
W

wally667

I tried again, when I click on new I get three options; Question, Suggestion
& General Comments. When I click on Question nothing happens. I have tried
this more than several times. When I click on Reply, I can get to this stage
where I can reply to your post. I'm stuck. wally667
 
W

wally667

Hi, when I click on New I get three options, Question, Suggestions &
Comments. I still cannot access the New function. I can access the reply
function very well. I still need assistance, thanks wally667
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top