Multiple match with max function

[ndblasa]

Hello,

I want to match several ranges to return the highest match as follows (this is a tweaked example that I found):

[TABLE="width: 299"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Order #[/TD]
[TD]Version[/TD]
[TD]Type[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]4[/TD]
[TD]a[/TD]
[TD]21/02/2013[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]2[/TD]
[TD]b[/TD]
[TD]28/04/2013[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]5[/TD]
[TD]a[/TD]
[TD]4/8/2013[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]3[/TD]
[TD]a[/TD]
[TD]27/09/2013[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]1[/TD]
[TD]b[/TD]
[TD]2/3/2014[/TD]
[/TR]
[TR]
[TD]54321[/TD]
[TD]3[/TD]
[TD]a[/TD]
[TD]31/03/2014[/TD]
[/TR]
[TR]
[TD]54321[/TD]
[TD]4[/TD]
[TD]a[/TD]
[TD]7/10/2014[/TD]
[/TR]
[TR]
[TD]54321[/TD]
[TD]1[/TD]
[TD]b[/TD]
[TD]13/12/2014[/TD]
[/TR]
[TR]
[TD]54321[/TD]
[TD]7[/TD]
[TD]b[/TD]
[TD]21/12/2014[/TD]
[/TR]
</tbody>[/TABLE]

I want to obtain a Date (column D) based on Order# AND Type. Let us assume that Order# = 54321 in cell F2 and Type = a in cell F3.

I have done this, with an error:
=INDEX(D3:D11,MATCH(MAX(IF(AND(A3:A11=F2,C3:C11=F3),B3:B11)),IF(AND(A3:A11=F2,C3:C11=F3),B3:B11),0))

(yes, I am using ctrl+shift for the array formula)

Any help?
Thanks

 

[ndblasa]

To make things clearer: I want the match to be with the highest version. So in this case it should return 7/10/2014 which is the highest match version for order 54321 and type a.

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Order #[/TD]
[TD]Version[/TD]
[TD]Type[/TD]
[TD]Date[/TD]
[TD][/TD]
[TD][/TD]
[TD]

54321​

[/TD]
[TD]

12345​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

12345​

[/TD]
[TD]

4​

[/TD]
[TD]a[/TD]
[TD]

2/21/2013​

[/TD]
[TD][/TD]
[TD]a[/TD]
[TD]

10/7/2014​

[/TD]
[TD]

9/27/2013​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

12345​

[/TD]
[TD]

2​

[/TD]
[TD]b[/TD]
[TD]

4/28/2013​

[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]

12/21/2014​

[/TD]
[TD]

3/2/2014​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

12345​

[/TD]
[TD]

5​

[/TD]
[TD]a[/TD]
[TD]

8/4/2013​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

12345​

[/TD]
[TD]

3​

[/TD]
[TD]a[/TD]
[TD]

9/27/2013​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

12345​

[/TD]
[TD]

1​

[/TD]
[TD]b[/TD]
[TD]

3/2/2014​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

54321​

[/TD]
[TD]

3​

[/TD]
[TD]a[/TD]
[TD]

3/31/2014​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]

54321​

[/TD]
[TD]

4​

[/TD]
[TD]a[/TD]
[TD]

10/7/2014​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

54321​

[/TD]
[TD]

1​

[/TD]
[TD]b[/TD]
[TD]

12/13/2014​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

54321​

[/TD]
[TD]

7​

[/TD]
[TD]b[/TD]
[TD]

12/21/2014​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

g2=MAX(IF($C$2:$C$10=$F2,IF($A$2:$A$10=G$1,$D$2:$D$10))) control+shift+enter copy across and down