Hi Bob Thanks for reply, that works ok to a point, can i explain what i'm
doing a bit better, I have a list of horses numbered 1:8, with the horses
name next to its number and 8 different races, in excel i have made a
programme with buttons using macros so when i press a button it prints out a
bettin slip with Race 1 Horse 1 or horse 2, so i have 8 buttons and 8 preset
slips i have made , when i put a one in a cell i want all the horses names
from the race one list to go in the correct betting slip. Hope you can help
Mike

"Bob Phillips" wrote:

VLOOKUP

=VLOOKUP(A1,M1:N10,2,False)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mike" wrote in message
...
how can i make it so when i put the number 1 in a cell it will put a name
in
the formula cell from a list and if i put number 2 a nother name from the
list and so on please

Thanks Mike