software

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

VLOOKUP

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Mikequot; gt; wrote in message
...
gt; how can i make it so when i put the number 1 in a cell it will put a name
in
gt; the formula cell from a list and if i put number 2 a nother name from the
gt; list and so on please
gt;
gt; Thanks Mike
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

quot;Bob Phillipsquot; wrote:

gt; VLOOKUP
gt;
gt; =VLOOKUP(A1,M1:N10,2,False)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Mikequot; gt; wrote in message
gt; ...
gt; gt; how can i make it so when i put the number 1 in a cell it will put a name
gt; in
gt; gt; the formula cell from a list and if i put number 2 a nother name from the
gt; gt; list and so on please
gt; gt;
gt; gt; Thanks Mike
gt;
gt;
gt;