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.