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