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
.