If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple IF function
Any assistance will be greatly appreciated.
I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other". Thank you in advance. |
#2
|
|||
|
|||
Multiple IF function
On Mar 23, 2:35*pm, Jecker wrote:
Any assistance will be greatly appreciated. * I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. *If false, then return 'Other'. * The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month *If they are not on the current team structure then reflect "Other". Thank you in advance. What is a "sine" of the employee? |
#3
|
|||
|
|||
Multiple IF function
"Sine" of the employee is an employee identifier - each employee is given a
number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other". Thank you in advance. What is a "sine" of the employee? . |
#4
|
|||
|
|||
Multiple IF function
On Mar 24, 7:58*am, Jecker wrote:
"Sine" of the employee is an employee identifier - each employee is given a number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. * I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. *If false, then return 'Other'. * The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month *If they are not on the current team structure then reflect "Other".. Thank you in advance. What is a "sine" of the employee? .- Hide quoted text - - Show quoted text - I'm not really understanding your need but hoping that this might work =INDEX($W$2:$W$272,MATCH(F300,F$2:F$272,0)) Lookup this value in this range and the "INDEX" column value is returned range with values to be looked up |
#5
|
|||
|
|||
Multiple IF function
Sorry, but I can't get this to work.
I have 1 file with 2 worksheets - 1st worksheet called 'employee information' and the 2nd worksheet 'current team structure'. Included in the 'Employee Information' is the following: Sine (this is the employee's assigned number) Month (this reflects the month the sale was made) Included in the 'Current team structure worksheet is: Sine (same as what is reflected in the 'employee information' worksheet Month Product I need a formula in to look at the sine and month reflected on the 'employee information' sheet and compare it to the sine and month on the 'current team structure' and return the 'product' . Is this more understandable? Thank you ! "Ziggy" wrote: On Mar 24, 7:58 am, Jecker wrote: "Sine" of the employee is an employee identifier - each employee is given a number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other".. Thank you in advance. What is a "sine" of the employee? .- Hide quoted text - - Show quoted text - I'm not really understanding your need but hoping that this might work =INDEX($W$2:$W$272,MATCH(F300,F$2:F$272,0)) Lookup this value in this range and the "INDEX" column value is returned range with values to be looked up . |
#6
|
|||
|
|||
Multiple IF function
Also, if the 'sine' from the 'Employee Information' worksheet cannot find the
employee on the 'current team structure' worksheet (therefore cannot return the 'product', I want it to return "Other". This will tell us that the employee is missing from the current team structure therefore a 'product' is not listed for them. Thanks again "Jecker" wrote: Sorry, but I can't get this to work. I have 1 file with 2 worksheets - 1st worksheet called 'employee information' and the 2nd worksheet 'current team structure'. Included in the 'Employee Information' is the following: Sine (this is the employee's assigned number) Month (this reflects the month the sale was made) Included in the 'Current team structure worksheet is: Sine (same as what is reflected in the 'employee information' worksheet Month Product I need a formula in to look at the sine and month reflected on the 'employee information' sheet and compare it to the sine and month on the 'current team structure' and return the 'product' . Is this more understandable? Thank you ! "Ziggy" wrote: On Mar 24, 7:58 am, Jecker wrote: "Sine" of the employee is an employee identifier - each employee is given a number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other".. Thank you in advance. What is a "sine" of the employee? .- Hide quoted text - - Show quoted text - I'm not really understanding your need but hoping that this might work =INDEX($W$2:$W$272,MATCH(F300,F$2:F$272,0)) Lookup this value in this range and the "INDEX" column value is returned range with values to be looked up . |
#7
|
|||
|
|||
Multiple IF function
Also, if the 'sine' from the 'Employee Information' worksheet cannot find the
employee on the 'current team structure' worksheet (therefore cannot return the 'product', I want it to return "Other". This will tell us that the employee is missing from the current team structure therefore a 'product' is not listed for them. Thanks again "Jecker" wrote: Sorry, but I can't get this to work. I have 1 file with 2 worksheets - 1st worksheet called 'employee information' and the 2nd worksheet 'current team structure'. Included in the 'Employee Information' is the following: Sine (this is the employee's assigned number) Month (this reflects the month the sale was made) Included in the 'Current team structure worksheet is: Sine (same as what is reflected in the 'employee information' worksheet Month Product I need a formula in to look at the sine and month reflected on the 'employee information' sheet and compare it to the sine and month on the 'current team structure' and return the 'product' . Is this more understandable? Thank you ! "Ziggy" wrote: On Mar 24, 7:58 am, Jecker wrote: "Sine" of the employee is an employee identifier - each employee is given a number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other".. Thank you in advance. What is a "sine" of the employee? .- Hide quoted text - - Show quoted text - I'm not really understanding your need but hoping that this might work =INDEX($W$2:$W$272,MATCH(F300,F$2:F$272,0)) Lookup this value in this range and the "INDEX" column value is returned range with values to be looked up . |
#8
|
|||
|
|||
Multiple IF function
Also, I need it to return 'Other' instead of the 'product' if it cannot match
to the employee on the 'current team structure (this would mean that the employee does not exist on the 'current team strucure' worksheet. The 'other' return will tell us that. Thank you "Ziggy" wrote: On Mar 24, 7:58 am, Jecker wrote: "Sine" of the employee is an employee identifier - each employee is given a number assigned to them when hired "Ziggy" wrote: On Mar 23, 2:35 pm, Jecker wrote: Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure. I need the formula to look at the month and sine on the 'employee information' against the month and sine on the 'current team structure' and return the Product. If false, then return 'Other'. The logic is to lookup the sine on the employee information and return the applicable Product from the current team structure based their sine and month If they are not on the current team structure then reflect "Other".. Thank you in advance. What is a "sine" of the employee? .- Hide quoted text - - Show quoted text - I'm not really understanding your need but hoping that this might work =INDEX($W$2:$W$272,MATCH(F300,F$2:F$272,0)) Lookup this value in this range and the "INDEX" column value is returned range with values to be looked up . |
Thread Tools | |
Display Modes | |
|
|