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.

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?

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?
.

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

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
.

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
.

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
.

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
.