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.