Multiple IF function

[Jecker]

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.

 

[Ziggy]

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?

 

[Jecker]

"Sine" of the employee is an employee identifier - each employee is given a
number assigned to them when hired

 

[Ziggy]

"Sine" of the employee is an employee identifier - each employee is givena
number assigned to them when hired






- 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

 

[Jecker]

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 !

 

[Jecker]

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]

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]

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