View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ziggy Ziggy is offline
external usenet poster
 
Posts: 47
Default 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?