Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple "if" forrmulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple "if" forrmulas
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple "if" forrmulas
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have multiple "If" statements in one formula? | Excel Discussion (Misc queries) | |||
Multiple "if" formulas | New Users to Excel | |||
multiple "if" arguments | Excel Discussion (Misc queries) | |||
return data in multiple columns using "if"? | Excel Discussion (Misc queries) | |||
Please, need help with multiple "if" conditions | Excel Discussion (Misc queries) |