Array Formula with multiple criteria

[dracron]

<br>
I have been using this array which works. But now I want to introduce multiple criteria.<br>
{=MIN(IF($X$2:$X$3550=B3,$AA$2:$AA$3550))}<br>
<br>
This formula returns the min date from AA if X and B have the same file number. What I also want to introduce is column Z which is a status name.<br>
If Column Z = "Ready for Review" and if X and B have the same file number then it provide min from AA.<br>
Ive tried using If(and but its not returning a result. Maybe I am not writing correctly?<br>
<br>
I hope I've explained this well.<br type="_moz">

 

[Andrew Poulsom]

That would be:

=MIN(IF($X$2:$X$3550=B3,IF($Z$2:$Z$3550="Ready for Review",$AA$2:$AA$3550)))

 

[dracron]

Drives me crazy when it was staring at me right the face the whole time! Thank you for your help.
Will this also work If I change MIN to MAX?

 

[Andrew Poulsom]

Drives me crazy when it was staring at me right the face the whole time! Thank you for your help.
Will this also work If I change MIN to MAX?

Yes.

 

[dracron]

I tried the formula you provided but it doesn't do quite what I need.

Its returning a result if it finds one or the other. I need it to return a result only if the status is ready for review and X and B match

 

[Andrew Poulsom]

Please post some sample date where the formula doesn't work as expected.