Date range V-LOOKUP

[pillr001]

Hello, this is my first time using forum. Wondering if some genius can help me.

Formula please that would return the price of ''Hi-tech 285w'' for what the price was at that time. So to have it look it for what the price was at 13/03/2018
for example the price between 10/02/2018 - 11/02/2018 was £200.00

[TABLE="width: 476"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Panel[/TD]
[TD]Dates - Dates[/TD]
[TD][/TD]
[TD]Price[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hi-Tech 285w[/TD]
[TD]10/02/2018[/TD]
[TD]11/02/2018[/TD]
[TD]£200.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hi-Tech 285w[/TD]
[TD]11/03/2018[/TD]
[TD]15/03/2018[/TD]
[TD]£201.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hi-Tech 285w[/TD]
[TD]12/04/2018[/TD]
[TD]15/04/2018[/TD]
[TD]£202.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Hi-Tech 285w [/TD]
[TD]Return price of when it was 13/03/2018[/TD]
[TD]

[/TD]
[TD]


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

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

 

[admiral100]

Hi,

Try this: an array formula Ctrl+Shift+Enter NOT just Enter

H2 =INDEX(D2:D4,MATCH(1,IF(F2=A2:A4,IF(G2>=B2:B4,IF(G2<=C2:C4,1))),0))

[TABLE="width: 680"]
<colgroup><col><col><col span="4"><col><col span="2"></colgroup><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]Panel[/TD]
[TD]Dates [/TD]
[TD]Dates[/TD]
[TD]Price[/TD]
[TD][/TD]
[TD]Panel[/TD]
[TD]Date[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Hi-Tech 285w[/TD]
[TD]10/02/18[/TD]
[TD]11/02/18[/TD]
[TD]£200.00[/TD]
[TD][/TD]
[TD]Hi-Tech 285w[/TD]
[TD]13/03/18[/TD]
[TD]£201.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Hi-Tech 285w[/TD]
[TD]11/03/18[/TD]
[TD]15/03/18[/TD]
[TD]£201.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Hi-Tech 285w[/TD]
[TD]12/04/18[/TD]
[TD]15/04/18[/TD]
[TD]£202.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[pillr001]

Thank you very much