Array formula based on 2 criterias

[forest1959]

Hi All

I know this will be pretty straight forward, but i'm struggling to ask the web the right question..

I have an array formula that brings back an "order number" in column E, based on the order date in column A

{=IF(ROWS(A$35:A35)>COUNTIF(Timesheets!$A2:$A2000,$E$31),"",INDEX(Timesheets!$E2:$E2000,SMALL(IF(Timesheets!$A2:$A2000=$E$31,ROW(Timesheets!$A2:$A2000)-ROW(Timesheets!$A$2)+1),ROWS(A$35:A35))))}

I just need to add another criteria based on the employee's name populated in column C

Below is an example of the results i'm looking for

[TABLE="width: 427"]
<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Criteria 1[/TD]
[TD]Criteria 2[/TD]
[TD]Results[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]05/04/2019[/TD]
[TD]Brian[/TD]
[TD]3456[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5678[/TD]
[/TR]
[TR]
[TD]31/03/2019[/TD]
[TD]Brian[/TD]
[TD]1234[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]31/03/2019[/TD]
[TD]Chris[/TD]
[TD]2345[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05/04/2019[/TD]
[TD]Brian[/TD]
[TD]3456[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05/04/2019[/TD]
[TD]Chris[/TD]
[TD]4567[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05/04/2019[/TD]
[TD]Brian[/TD]
[TD]5678[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05/04/2019[/TD]
[TD]Chris[/TD]
[TD]6789[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

regards
Paul

 

[forest1959]

Got it.. Thank you so much

Your final attempt, (and maybe even the one before worked), it was just missing the $ from the column numbers which i missed out on my original example..

Thank you once again, and apologies for my glaring error

regards
Paul

 

[James006]

Is it just the absolute reference which was messing it up ...

[COLOR=#333333][I]=IF(ROWS(A$35:A35)>COUNTIF(Timesheets!$A2:$A2000,$E$31),"",INDEX(Timesheets!$E2:$E2000,SMALL(IF(Timesheets!$C2:$C2000=$F$31,IF(Timesheets!$A2:$A2000=$E$31,ROW(Timesheets!$A2:$A2000)-ROW(Timesheets!$A$2)+1)),ROWS(A$35:A35))))[/I][/COLOR]

Let's hope ...

 

[forest1959]

Is it just the absolute reference which was messing it up ...

[COLOR=#333333][I]=IF(ROWS(A$35:A35)>COUNTIF(Timesheets!$A2:$A2000,$E$31),"",INDEX(Timesheets!$E2:$E2000,SMALL(IF(Timesheets!$C2:$C2000=$F$31,IF(Timesheets!$A2:$A2000=$E$31,ROW(Timesheets!$A2:$A2000)-ROW(Timesheets!$A$2)+1)),ROWS(A$35:A35))))[/I][/COLOR]

Let's hope ...

Yes it was.. Apologies once again..

Thank you for your time

 

[James006]

You are welcome ...

Glad it is all sorted out ...