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

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

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

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



.

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



.

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



.


.