Hello All,
I need some help!
I am keep track of the number of jobs an employee does. I'm and trying to get the value of a cell if it meets two criteria.
Example:
If A2:A90 contain "Joe" and B2:B90=September then give me C2 in the same row.
So if these two criteria are true then give me C2 in the same row where the two criteria were true
Not sure how to write the formula for this??????
I was trying
[/code]
{=VLOOKUP(IF(AND('Team Data'!A2:A15='Coordinator Profile'!D2:E2,'Team Data'!B2:B15='Coordinator Profile'!D6:E6),0,0),'Team Data'!A2:T14,4,FALSE)}
It is something I am doing wrong.....
Please help!
I need some help!
I am keep track of the number of jobs an employee does. I'm and trying to get the value of a cell if it meets two criteria.
Example:
If A2:A90 contain "Joe" and B2:B90=September then give me C2 in the same row.
So if these two criteria are true then give me C2 in the same row where the two criteria were true
Not sure how to write the formula for this??????
I was trying
[/code]
{=VLOOKUP(IF(AND('Team Data'!A2:A15='Coordinator Profile'!D2:E2,'Team Data'!B2:B15='Coordinator Profile'!D6:E6),0,0),'Team Data'!A2:T14,4,FALSE)}
It is something I am doing wrong.....
Please help!