INDEX MATCH Dates

EasterGreen

New Member
Joined
Sep 7, 2009
Messages
49
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:
Product1-Jan-151-Jan-161-Jan-171-Jan18
Prod1$5$5.50$5.75$6
Prod2$6$6.25$6.5$6.74
Prod3etc
Prod3

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,111
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,475
Messages
5,529,062
Members
409,849
Latest member
J7House1984
Top