INDEX result with date criteria & skip empty cell

[phithack]

[TABLE="width: 350"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"] G [/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]DATE[/TD]
[TD="align: center"]FROM[/TD]
[TD="align: center"]TO[/TD]
[TD="align: center"]PRICE[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]01-03-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Z[/TD]
[TD]18,900[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]10-03-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Z[/TD]
[TD]18,500[/TD]
[TD][/TD]
[TD]DATE : [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]29-03-18[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]Z[/TD]
[TD]18,900[/TD]
[TD][/TD]
[TD]FROM :[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]11-04-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Z[/TD]
[TD][/TD]
[TD][/TD]
[TD]TO :[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]18-04-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Z[/TD]
[TD]19,500[/TD]
[TD][/TD]
[TD]RESULT :[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]18-04-18[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]Z[/TD]
[TD]19,800[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]26-04-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Z[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]27-04-18[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]27-04-18[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

HI, I want to extract result (G6) that would skip empty cell if I input data DATE (G3), FROM (G4), TO (G5) for examples:

EX1:

DATE : 26-04-18
FROM : A
TO : Z
RESULT : 19,500 (D6)

EX2:

DATE : 12-04-18
FROM : A
TO : Z
RESULT : 18,500 (D3)


Sorry for my bad English
Thank you so much

 

[Peter_SSs]

Sorry Peter..
My bad..
I'm using Excel 2007..

Thank you for trying to help me..

No problem, but AGGREGATE wasn't introduced until Excel 2010 so that was the issue.

However, still for that first problem, you could also try this similarly compact standard-entry formula.

Excel Workbook
	A	B	C	D	E	F	G
1	DATE	FROM	TO	PRICE
2	1/03/2018	A	Z	18,900
3	10/03/2018	A	Z	18,500		DATE :	12/04/2018
4	29/03/2018	B	Z	18,900		FROM :	A
5	11/04/2018	A	Z			TO :	Z
6	18/04/2018	A	Z	19,500		RESULT :	18500
7	18/04/2018	B	Z	19,800
8	26/04/2018	A	Z
9	27/04/2018	A	Y
10	27/04/2018	B	Y
Skip Empty