DoodlesMama
New member
- Joined
- Oct 17, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hello,
I am trying to return the oldest date within calls that match the SLA code and the region. I've used the formula listed below in the attached workbook, but it's not working. Can anyone please help me figure out a solution?
Formula:
=IF(AND($A$4:$A$7=Sheet2!$D$2:$D$497,$B$3="SLA4"),MIN(VLOOKUP(A5:A8,Sheet2!$D$455:$F$497,3,FALSE)),"")
View attachment OPEN_CALL.xlsx
I am trying to return the oldest date within calls that match the SLA code and the region. I've used the formula listed below in the attached workbook, but it's not working. Can anyone please help me figure out a solution?
Formula:
=IF(AND($A$4:$A$7=Sheet2!$D$2:$D$497,$B$3="SLA4"),MIN(VLOOKUP(A5:A8,Sheet2!$D$455:$F$497,3,FALSE)),"")
View attachment OPEN_CALL.xlsx