INDEX MATCH Dates

[EasterGreen]

Just can't get this to work.
I have products where the price changes over time and need to historically check these.
Inputs are "Prod1" and "23-MAR-18". Output should be $5.00.
Table:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]1-Jan-15[/TD]
[TD]1-Jan-16[/TD]
[TD]1-Jan-17[/TD]
[TD]1-Jan18[/TD]
[/TR]
[TR]
[TD]Prod1[/TD]
[TD]$5[/TD]
[TD]$5.50[/TD]
[TD]$5.75[/TD]
[TD]$6[/TD]
[/TR]
[TR]
[TD]Prod2[/TD]
[TD]$6[/TD]
[TD]$6.25[/TD]
[TD]$6.5[/TD]
[TD]$6.74[/TD]
[/TR]
[TR]
[TD]Prod3[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Prod3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

5? Do you mean 6?

=INDEX(A1:E5,MATCH(H1,A1:A5,0),MATCH(H2,A1:E1,1))

where H1 has the Prod and H2 the date.

 

[EasterGreen]

Perfect, was trying to put > in the formula.
Thank you.