Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    North Providence, Rhode Island, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have to assign player numbers and tee times for a list of 35 members of a golf team. Each day, I have to enter the same names but different order and am looking for a short cut to save time. I have assined the numbers 1-35 to each member and wish to type in the number and have their name appear in the cell. I have attached a sample worksheet. I am not sure if it's VLOOKUP or LOOKUP and requires also and input statement. Help!
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can use this formula to look up the associated name:
    =VLOOKUP(C5,$A$17:$B$51,False)
    This implies however that you need your input table twice: once to input the numbers and once to actually show the names.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='elorenzo' post='773859' date='06-May-2009 01:05']l have assined the numbers 1-35 to each member and wish to type in the number and have their name appear in the cell.[/quote]

    =VLOOKUP(C5,A$17:B$51,2,0)


    Regards
    Bosco

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='elorenzo' post='773859' date='05-May-2009 20:05']I have to assign player numbers and tee times for a list of 35 members of a golf team. Each day, I have to enter the same names but different order and am looking for a short cut to save time. I have assined the numbers 1-35 to each member and wish to type in the number and have their name appear in the cell. I have attached a sample worksheet. I am not sure if it's VLOOKUP or LOOKUP and requires also and input statement. Help! [/quote]

    A solution using data validation is provided in the attached file.
    Attached Files Attached Files
    Regards
    Don

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    North Providence, Rhode Island, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='773874' date='06-May-2009 04:49']You can use this formula to look up the associated name:
    =VLOOKUP(C5,$A$17:$B$51,False)
    This implies however that you need your input table twice: once to input the numbers and once to actually show the names.[/quote]

    Thank you
    However, I am not sure on how to put the input statement in. Each time I try, it deletes the content of the cell and I have the table in twice. Thanks again.

    Ed

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Please have a look if the attached file clarifies what I tried to explain earlier.
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    North Providence, Rhode Island, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='773921' date='06-May-2009 14:01']Please have a look if the attached file clarifies what I tried to explain earlier.[/quote]
    Thank you so much--it is exactly what I am looking for.

Posting Permissions

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