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 |
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 |
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 |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com