Match Multiple Criteria & Find Oldest Date

DoodlesMama · Oct 17, 2013

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

jsuarezg · Oct 18, 2013

Hello, I found an application similar to yours. See this page, http://exceltotal.com/buscar-un-valor-y-regresar-multiples-resultados-en-excel/

I think you can do this and is going to work in your case.

Canapone · Oct 18, 2013

Min(if

Hi,

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

Hope it helps

Match Multiple Criteria & Find Oldest Date

DoodlesMama

New member

jsuarezg

New member

Canapone

New member

Attachments