A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to change a number to name



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2005, 11:20 AM
external usenet poster
 
Posts: n/a
Default how to change a number to name

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
  #2  
Old April 13th, 2005, 12:52 PM
Fredrik Wahlgren
external usenet poster
 
Posts: n/a
Default


wrote in message
...
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


  #3  
Old April 13th, 2005, 03:36 PM
Kassie
external usenet poster
 
Posts: n/a
Default

If your list of names is not numbered at present, then insert a column to the
left, where you can insert the relevant numbers, e.g. A2 = 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers, you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in message
...
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



  #4  
Old April 13th, 2005, 09:31 PM
external usenet poster
 
Posts: n/a
Default

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.
-----Original Message-----
If your list of names is not numbered at present, then

insert a column to the
left, where you can insert the relevant numbers, e.g. A2

= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,

you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in message
...
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



.

  #5  
Old April 13th, 2005, 09:42 PM
Kassie
external usenet poster
 
Posts: n/a
Default

Hi

Let's say you have your list in Sheet 2, and your schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the cell next to the
number you wnat to reference. For the sake of this example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP(C1,Sheet2!A:B,2))
If you do not have the number available, it will show Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present, then

insert a column to the
left, where you can insert the relevant numbers, e.g. A2

= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,

you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in message
...
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



.


  #6  
Old April 14th, 2005, 12:34 AM
external usenet poster
 
Posts: n/a
Default

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.
-----Original Message-----
Hi

Let's say you have your list in Sheet 2, and your

schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the

cell next to the
number you wnat to reference. For the sake of this

example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP

(C1,Sheet2!A:B,2))
If you do not have the number available, it will show

Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present,

then
insert a column to the
left, where you can insert the relevant numbers, e.g.

A2
= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,

you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in

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



.


.

  #7  
Old April 18th, 2005, 01:48 PM
Kassie
external usenet poster
 
Posts: n/a
Default

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.

" wrote:

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.
-----Original Message-----
Hi

Let's say you have your list in Sheet 2, and your

schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the

cell next to the
number you wnat to reference. For the sake of this

example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP

(C1,Sheet2!A:B,2))
If you do not have the number available, it will show

Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present,

then
insert a column to the
left, where you can insert the relevant numbers, e.g.

A2
= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,
you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in

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



.


.


  #8  
Old April 19th, 2005, 11:41 AM
wally667
external usenet poster
 
Posts: n/a
Default

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.

"Kassie" wrote:

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.

" wrote:

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.
-----Original Message-----
Hi

Let's say you have your list in Sheet 2, and your

schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the

cell next to the
number you wnat to reference. For the sake of this

example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP

(C1,Sheet2!A:B,2))
If you do not have the number available, it will show

Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present,

then
insert a column to the
left, where you can insert the relevant numbers, e.g.

A2
= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,
you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in

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



.


.


  #9  
Old April 19th, 2005, 11:51 AM
Kassie
external usenet poster
 
Posts: n/a
Default

Hi there, glad you got sorted out. When reading the posts, there are 3
options in the header bar, New, Reply and Show. Click on New, and select
Start a new thread.
That is on
http://www.microsoft.com/office/comm...t.public.excel.
and then select the category you want, i.e General, New Users, Application
Errors, Charts, Setup, Programming or Worksheet Functions

Regards

"wally667" wrote:

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.

"Kassie" wrote:

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.

" wrote:

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.
-----Original Message-----
Hi

Let's say you have your list in Sheet 2, and your
schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the
cell next to the
number you wnat to reference. For the sake of this
example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP
(C1,Sheet2!A:B,2))
If you do not have the number available, it will show
Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present,
then
insert a column to the
left, where you can insert the relevant numbers, e.g.
A2
= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,
you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in
message
...
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



.


.


  #10  
Old April 19th, 2005, 12:15 PM
wally667
external usenet poster
 
Posts: n/a
Default

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

"Kassie" wrote:

Hi there, glad you got sorted out. When reading the posts, there are 3
options in the header bar, New, Reply and Show. Click on New, and select
Start a new thread.
That is on
http://www.microsoft.com/office/comm...t.public.excel.
and then select the category you want, i.e General, New Users, Application
Errors, Charts, Setup, Programming or Worksheet Functions

Regards

"wally667" wrote:

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.

"Kassie" wrote:

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.

" wrote:

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.
-----Original Message-----
Hi

Let's say you have your list in Sheet 2, and your
schedule in Sheet 1

So, in sheet 1 you will enter the next formula in the
cell next to the
number you wnat to reference. For the sake of this
example, say the number
is in Cell C1, and you want the name in C2.

=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP
(C1,Sheet2!A:B,2))
If you do not have the number available, it will show
Not Known, else it
will show the name

" wrote:

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.
-----Original Message-----
If your list of names is not numbered at present,
then
insert a column to the
left, where you can insert the relevant numbers, e.g.
A2
= 1, B2 = Say Pete
Summers.

Where you want to show these names, based on numbers,
you can then use a
VLOOKUP formula

"Fredrik Wahlgren" wrote:


wrote in
message
...
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



.


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of objects thomak General Discussion 3 February 17th, 2005 12:58 PM
how do i change number of lines per page in Word? childeroland New Users 9 December 29th, 2004 04:53 PM
incorrect sums in report using 2 tables jkendrick75 Setting Up & Running Reports 22 December 13th, 2004 03:19 PM
Restart Autonumber Traci New Users 22 July 21st, 2004 01:10 AM


All times are GMT +1. The time now is 01:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.