Match Multiple Criteria & Find Oldest Date

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
 

Canapone

New member
Joined
Oct 3, 2011
Messages
99
Reaction score
0
Points
0
Location
Italy
Excel Version(s)
Excel 2010
Min(if

Hi,

an attempt: All formulas must be confirmed with control+shift+enter.

Hope it helps
 

Attachments

  • OPEN_CALL.xlsx
    56.4 KB · Views: 95
Top