Try this (array entered):

=IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B 5)*(I9:I20=B9),Timesheet!G9:G20)),"")

--
Biff
Microsoft Excel MVP


wrote in message
...
Hello,

I am using this array formula to give me the smallest date if two
ciretira are matched.
It works really well, but for some reason if there is no date in the
list it returns the 00-Jan-00 value.
Is there a way that it does not return any values at all and the cell
remains empty?

=MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," ")))

Thanks!