EasterGreen
Board Regular
- Joined
- Sep 7, 2009
- Messages
- 50
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:
<tbody>
</tbody>
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>