+ Reply to Thread
Results 1 to 11 of 11

how to change a number to name

  1. #1
    Guest

    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. #2
    Fredrik Wahlgren
    Guest

    Re: how to change a number to name


    <[email protected]> wrote in message
    news:[email protected]...
    > 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. #3
    Kassie
    Guest

    Re: how to change a number to name

    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:

    >
    > <[email protected]> wrote in message
    > news:[email protected]...
    > > 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. #4
    Guest

    Re: how to change a number to name

    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:
    >
    >>
    >> <[email protected]> wrote in message
    >> news:[email protected]...
    >> > 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. #5
    Kassie
    Guest

    Re: how to change a number to name

    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

    "[email protected]" 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:
    > >
    > >>
    > >> <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > 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. #6
    Guest

    Re: how to change a number to name

    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
    >
    >"[email protected]" 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:
    >> >
    >> >>
    >> >> <[email protected]> wrote in

    message
    >> >> news:[email protected]...
    >> >> > 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. #7
    Kassie
    Guest

    Re: how to change a number to name

    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.

    "[email protected]" 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
    > >
    > >"[email protected]" 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:
    > >> >
    > >> >>
    > >> >> <[email protected]> wrote in

    > message
    > >> >> news:[email protected]...
    > >> >> > 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. #8
    wally667
    Guest

    Re: how to change a number to name

    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.
    >
    > "[email protected]" 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
    > > >
    > > >"[email protected]" 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:
    > > >> >
    > > >> >>
    > > >> >> <[email protected]> wrote in

    > > message
    > > >> >> news:[email protected]...
    > > >> >> > 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. #9
    Kassie
    Guest

    Re: how to change a number to name

    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.
    > >
    > > "[email protected]" 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
    > > > >
    > > > >"[email protected]" 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:
    > > > >> >
    > > > >> >>
    > > > >> >> <[email protected]> wrote in
    > > > message
    > > > >> >> news:[email protected]...
    > > > >> >> > 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. #10
    wally667
    Guest

    Re: how to change a number to name

    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.
    > > >
    > > > "[email protected]" 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
    > > > > >
    > > > > >"[email protected]" 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:
    > > > > >> >
    > > > > >> >>
    > > > > >> >> <[email protected]> wrote in
    > > > > message
    > > > > >> >> news:[email protected]...
    > > > > >> >> > 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
    > > > > >> >>
    > > > > >> >>
    > > > > >> >>
    > > > > >> >.
    > > > > >> >
    > > > > >>
    > > > > >.
    > > > > >
    > > > >


  11. #11
    wally667
    Guest

    Re: how to change a number to name

    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

    "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.
    > > >
    > > > "[email protected]" 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
    > > > > >
    > > > > >"[email protected]" 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:
    > > > > >> >
    > > > > >> >>
    > > > > >> >> <[email protected]> wrote in
    > > > > message
    > > > > >> >> news:[email protected]...
    > > > > >> >> > 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
    > > > > >> >>
    > > > > >> >>
    > > > > >> >>
    > > > > >> >.
    > > > > >> >
    > > > > >>
    > > > > >.
    > > > > >
    > > > >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1