max value with multiple condition

[faizee]

S#	Name	Date	Month	Year	sale
1	john	01	Feb	2012	234343
2	zeeshan	02	Feb	2012	2343
3	faizan	06	Mar	2012	9898
4	jawed	04	Mar	2012	2222
5	ahsan	08	Apr	2012	9000
6	ahsan	05	Mar	2012	222
7	faizan	03	Feb	2012	11111
8	faizan	03	Apr	2012	39434
9	faizan	03	Apr	2012	9832943
	Max value with the following conditions
	Name: Faizan
	Date: 3
	Month: Apr
	Year: 2012

<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

S#	Name	Date	Month	Year	sale
1	john	01	Feb	2012	234343
2	zeeshan	02	Feb	2012	2343
3	faizan	06	Mar	2012	9898
4	jawed	04	Mar	2012	2222
5	ahsan	08	Apr	2012	9000
6	ahsan	05	Mar	2012	222
7	faizan	03	Feb	2012	11111
8	faizan	03	Apr	2012	39434
9	faizan	03	Apr	2012	9832943
	Max value with the following conditions
	Name: Faizan
	Date: 3
	Month: Apr
	Year: 2012

<tbody>
</tbody>

S#	Name	Date	Month	Year	sale		Name:	Faizan
1	john	1	Feb	2012	234343		Date:	3
2	zeeshan	2	Feb	2012	2343		Month:	Apr
3	faizan	6	Mar	2012	9898		Year:	2012
4	jawed	4	Mar	2012	2222			9832943
5	ahsan	8	Apr	2012	9000
6	ahsan	5	Mar	2012	222
7	faizan	3	Feb	2012	11111
8	faizan	3	Apr	2012	39434
9	faizan	3	Apr	2012	9832943

<tbody>
</tbody>

I5, control+shift+enter, not just enter:

=MAX(
   IF($B$2:$B$10=I1,
   IF($C$2:$C$10=I2,
   IF($D$2:$D$10=I3,
   IF($E$2:$E$10=I4,
    $F$2:$F$10)))))