Karen Schaefer
asked on
Lookup and if statements or index Match on several columns
I am looking for the correct syntax to lookup the value of the Salary for certain employees where Resource Type = "Salaried/W-2"
if the Names match, same date and resource type is correct then return the salary value / 12 months.
this what I have so far.
=IF([@Resource]=SalaryDeta il_Data!A: A,IF([@Dat es]=Salary Detail_Dat a!C:C,IF([ @ResourceT ype]="Sala ried/W-2", SalaryDeta il!D:D)/12 ))
What am I missing?
K
sample.xlsm
if the Names match, same date and resource type is correct then return the salary value / 12 months.
this what I have so far.
=IF([@Resource]=SalaryDeta
What am I missing?
K
sample.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks that did the trick
=IFERROR(IF([@ResourceType
If the above formula doesn't work in your real workbook, could you please make a Table where you want the formula to go, and add a worksheet SalaryDetail_Data so I can test the looking up.
Note that if a name occurs more than once in SalaryDetail_Data, the last salary found will be returned.
sample-1Q28929389.xlsm