Solved: Array Formula Question

[akreidler]

Not sure where to put this question but I am looking to nest another If statement inside an array formula where if the Array Formula answer = "01/01/2020" then I want it to return "No Start Date". Here is my array formula:

{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}

So here is the formula I would want to see:

If({=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}="01/01/2020","No Start Date",{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}

Hope someone can help me!

[GarysStudent]

just drop the "=" in the second line

[akreidler]

Does the whole formula need to become an array? Do you mean:

If({=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}="01/01/2020","No Start Date",{MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}

Or do you mean

{If(MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))="01/01/2020","No Start Date",MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}

[GarysStudent]

Its only a single array formula.

[Bob Phillips]

Like this

=IF(MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))=--"2020/01/01",
"No Start Date",
MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500)))

array entered.

[akreidler]

Thanks for your help. It worked exactly how I wanted it. I appreciate it