Help with Index

[rskip]

I have this formula:
=IFERROR(INDEX(' Week 1'!M$4:M$102,MATCH(B1730,IF(' Week 1'!A$4:A$102=AR$1726,' Week 1'!C$4:C$102),0))/10000/86400,"DNCL")
Which works.
However because of new data I have 2 separate entries and I want the formula to return the entry that is the smaller of the two !

Help Please !
Thanks in advance

 

[StephenCrump]

Try: =IFERROR(MIN(FILTER(' Week 1'!M$4:M$102,(' Week 1'!A$4:A$102=AR$1726)*(' Week 1'!C$4:C$102=B1730)))/864000000,"DNCL")

 

[kvsrinivasamurthy]

Try

=IFERROR(SMALL(IF(B1730=IF(' Week 1'!A$4:A$102=AR$1726,' Week 1'!C$4:C$102),' Week 1'!M$4:M$102),1)/10000/86400,"DNCL")