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:

Product	1-Jan-15	1-Jan-16	1-Jan-17	1-Jan18
Prod1	$5	$5.50	$5.75	$6
Prod2	$6	$6.25	$6.5	$6.74
Prod3	etc
Prod3

<tbody>
</tbody>

 

[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.