1. 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!

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

3. [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. [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.

5. [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. Please have a look if the attached file clarifies what I tried to explain earlier.

7. [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
•