Match Multiple Criteria & Find Oldest Date

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)),"")

OPEN_CALL.xlsx

Thank you so much for your help, but I'm getting 9/13/13, which is a SLA24. Table 1 is for SLA4 calls, so the oldest SLA4 call in Region 7988 is 10/10/13. Maybe my request wasn't clear. (sorry) The solution should meet both criteria, in that it should match the region and SLA4 detailed in column B. I have listed more detail below.

Before it can return the oldest date, I need it to match two criteria in each table:
Table 1
Sheet2, column B = Sheet1, $B$6 = Filter only SLA4
Sheet2, column D = Sheet1, $A7 = Filter only Region 7988 (total of 9 rows)
===> Oldest call = Column F (Contact Date) = Oldest Call = 10/10/13

Table 2
Sheet2, column B = Sheet1, $F$6 = Filter only SLA24
Sheet2, column D = Sheet1, $E7 = Filter only Region 7988 (total of 77 rows)
===> Oldest call = Column F (Contact Date) = Oldest Call = 9/13/13

Hopefully description that is more accurate. :D

I'm getting a #N/A error. I am using named ranges in my master report because it's fairly large. I changed your formula to reflect them per below:

{=MIN(IF(SLA4_REGION1&$C$3=REGION1&SLA1,CONTACT_DATE1))}

Would that make a difference?

I am building this into a VBA Macro, so feel free to suggest one if there is a way to do that.

Ooops, sorry!
{=MIN(IF(SLA4_REGION1&$C$3=REGION1&SLA1,CONTACT_DATE1))}

SLA4_REGION1 = 1st group of 4 regions in SLA4 TABLE

Used to match necessary criteria from REGION1 column on data sheet.

$C$3 = cell where "SLA4" text is found.

Used to match necessary criteria SLA1 column on data sheet.

CONTACT_DATE1 = Column in on data sheet where oldest call is found for noted region & SLA call type.

	$C$3 = SLA4
AREA / REGION	SLA4	OLDEST CALL
7988-NY/NJ/CT REGION	count
7985-CAPITOL REGION	count
7980-NEW ENGLAND REGION	count
7976-MID-ATLANTIC REGION	count

Hopefully this makes sense.

YOU ROCK!!

I finally got it to work!!

Two things:
1. When there are zero calls it's returning a 1/0/1900 date. I tried putting a ,""))} in the formula so it will just leave the cell blank, it still gives the same date.

My formula is:{=MIN(IF($B$4&$C$3=REGION1&SLA1,CONTACT_DATE1,""))}

2. I'm automating this for VBA. Since this is an array formula (requires CTRL+SHIFT+ENTER), is there anything special I should do, or will it be ok when I record the macro?

I cannot thank you enough for your help!!!

The exact above did not work, but I ended up with the formulas below and it worked!! Wooo Hooo!!

=IF(MIN(IF($B4&$C$3=REGION1&SLA1,CONTACT_DATE1)),MIN(IF($B4&$C$3=REGION1&SLA1,CONTACT_DATE1)),"")


and for VBA
[SLA4_REG_7988].Select
Selection.FormulaArray = _
"=IF(MIN(IF(R4C2&R3C3=REGION1&SLA1,CONTACT_DATE1)),MIN(IF(R4C2&R3C3=REGION1&SLA1,CONTACT_DATE1)),"")"
[SLA4_REG_7988] = [SLA4_REG_7988].Value

Thank you so much!!

That one doesn't work. is it the = sign after the first formula group?

Hello!
I need a little additional help if possible. I have been asked to add additional information to the same table utilizing the below formula. The formula Fdibbins provided below may need to be utilized to create the new formula, as there is a call number associated with the oldest date the formula provided.

FORMULA HELP.jpg

OK... I've attached a sample copy of my workbook. The formula below works for the first cell, but it gives the same call number no matter what the oldest date is. So I'm not sure what the issue is.

{=IF(IF(MIN(IF($A$3&$A$1=REGION1&SLA_1,CONTACT_DATE_TIME1)),MIN(IF($A$3&$A$1=REGION1&SLA_1,CONTACT_DATE_TIME1)),""),CALL_NUM1,"")}

Hopefully you can help.

OPEN_CALL1.xlsx

Never mind!! I figured it out.
Used: =INDEX(CALL_DATA1,MATCH(MIN(IF($B5&"SLA4"=REGION1&SLA1,CONTACT_DATE_TIME1)),CONTACT_DATE_TIME1,0),COLUMN(CALL_NUM1)) and Ctrl+Shift+Enter.