alocating a number to a name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a work sheet for playing a round robin in 8-ball.
Therefore I would like to allocate a number to a name, so that when I type
in numbers it gives me the persons names.
eg. 1 = Paul and 2 = Andrew
so when I put in 1 v 2 it shows that Paul is playing Andrew.
 
Take a look at VLOOKUP in help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
The Function Choose() might work for you'

In A1:A2 - enter Paul, Andrew
In B1: enter =Choose(A1,"Paul","Andrew") << Copy down to B2
In D1: enter =B1 & " is playing " & B2

Choose can take up to 29 arguments
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup row number 3
match name and show total result 2
Pivot Table counting a range 1
Summing VLookup from a variable number of sheets 4
lookup in a matrix 2
Code to add wroksheets to a workbook 4
Counting Names in a List 1
Counting how many numbers and letters appear in a particular row 7

Back
Top