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

"Bob Phillips" wrote in message
:

Take a look at VLOOKUP in help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Prez" wrote in message
...
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.