| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function
You can only add 7 conditions. What do you do if you have more then 7? Is
there another function? Thanks, Kristin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Hi,
an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Sure.
Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "Eduardo" wrote: Hi, an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Hi,
If you want to assign the name to the year, you need somewhere to have the years and beside it the names, let's say that you have a worksheet called Names and in column A you have the years and in column B the names you assign then in your worksheet column H enter the formula =INDEX(Names!$a$1:$a$100,MATCH(g2,Names!$B$1:$B$10 0,0)) copy the formula down "mygsdsni" wrote: Sure. Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "Eduardo" wrote: Hi, an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
oopss i mix the columns use this
=INDEX(Names!$b$1:$b$100,MATCH(g2,Names!$a$1:$a$10 0,0)) "Eduardo" wrote: Hi, If you want to assign the name to the year, you need somewhere to have the years and beside it the names, let's say that you have a worksheet called Names and in column A you have the years and in column B the names you assign then in your worksheet column H enter the formula =INDEX(Names!$a$1:$a$100,MATCH(g2,Names!$B$1:$B$10 0,0)) copy the formula down "mygsdsni" wrote: Sure. Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "Eduardo" wrote: Hi, an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Super. Can I make it sheet 2 in the same worksheet? If so, how do I refer
to that? "Eduardo" wrote: oopss i mix the columns use this =INDEX(Names!$b$1:$b$100,MATCH(g2,Names!$a$1:$a$10 0,0)) "Eduardo" wrote: Hi, If you want to assign the name to the year, you need somewhere to have the years and beside it the names, let's say that you have a worksheet called Names and in column A you have the years and in column B the names you assign then in your worksheet column H enter the formula =INDEX(Names!$a$1:$a$100,MATCH(g2,Names!$B$1:$B$10 0,0)) copy the formula down "mygsdsni" wrote: Sure. Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "Eduardo" wrote: Hi, an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Okay. I copied this formula in, found the worksheet and sheet number to
refer to and the formula changed to this =INDEX([Names]Sheet2!$B$1:$B$100,MATCH(G2,[Names]Sheet2!$A$1:$A$100,0)) and the column reslts are #N/A "Eduardo" wrote: oopss i mix the columns use this =INDEX(Names!$b$1:$b$100,MATCH(g2,Names!$a$1:$a$10 0,0)) "Eduardo" wrote: Hi, If you want to assign the name to the year, you need somewhere to have the years and beside it the names, let's say that you have a worksheet called Names and in column A you have the years and in column B the names you assign then in your worksheet column H enter the formula =INDEX(Names!$a$1:$a$100,MATCH(g2,Names!$B$1:$B$10 0,0)) copy the formula down "mygsdsni" wrote: Sure. Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "Eduardo" wrote: Hi, an example and the results you are looking for will help, thanks "mygsdsni" wrote: You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Excel 2007, or use an alternative such as VLOOKUP if that suits your
problem. Or reformulate your formula. What are you trying to do? -- David Biddulph "mygsdsni" wrote in message ... You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Sure.
Column G are different years in no paricular order, i.e; 1997, 1999, 2002, 2008 I need column H to choose a name that is not listed in this worksheet, rather one I assign so I am not sure that I can use vlookup, i.e; IF 1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF 2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names. "David Biddulph" wrote: Excel 2007, or use an alternative such as VLOOKUP if that suits your problem. Or reformulate your formula. What are you trying to do? -- David Biddulph "mygsdsni" wrote in message ... You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
