Array Formula Help

[Monica Austin]

Hey Guys, 

I am using an array formula to find the oldest invoice date for a particular customer in another sheet. 

Array Formula: {=MIN(IF('Raw Building'!$C:$C=Summary!A5,'Raw Building'!$D:$D,""))}

Wondering if I can use an IfError formula or alike so that if this customer does not have an invoice, it comes up N/A instead of putting a basic date in the return cell eg. 1/1/04.

If there is an easier formula, I am open to suggestions. 

Thanks

Monica

[#2]

Hi Monica,

To check if the customer invoice is missing, you can use this one:

=IF(ISNUMBER(MATCH(A2,'Raw Building'!$A:$A,0)),MIN(IF('Raw Building'!$A:$A=A2,'Raw Building'!$B:$B,"")),"n/a")

Or this:

=IF(MIN(IF('Raw Building'!$A:$A=A2,'Raw Building'!$B:$B,""))<>0,MIN(IF('Raw Building'!$A:$A=A2,'Raw Building'!$B:$B,"")),"n/a")

Please find the attached file.

Regards