DanishOrange
New Member
- Joined
- Feb 10, 2019
- Messages
- 10
I am wanting to search a price table with a number of columns; store, product, date range (from /to) & price.
I have the elements I of the store , product and exact date within the range an looking to get the price as an output.
I have tried all sorts and can't get a working approach, this is of course a small example table the real one isn't that much bigger (perhaps 1,000 rows).
Any thoughts? thanks for your help
<tbody>
</tbody>
I have the elements I of the store , product and exact date within the range an looking to get the price as an output.
I have tried all sorts and can't get a working approach, this is of course a small example table the real one isn't that much bigger (perhaps 1,000 rows).
Any thoughts? thanks for your help
A | B | C | D | E | ||
1 | STORE | PRODUCT | FROM | TO | PRICE | |
2 | BOBSTORE | PRC1 | 01/01/2015 | 31/12/2017 | 4.00 | |
3 | BOBSTORE | PRC2 | 01/01/2015 | 31/12/2017 | 2.00 | |
4 | BOBSTORE | PRC1 | 01/01/2018 | 31/12/2025 | 4.15 | |
5 | STEVESTORE | PRC1 | 01/01/2015 | 31/12/2018 | 3.90 | |
6 | STEVESTORE | PRC1 | 01/01/2019 | 31/12/2020 | 4.45 | |
7 | STEVESTORE | PRC2 | 01/01/2015 | 31/12/2020 | 1.95 | |
8 | ||||||
9 | BOBSTORE | PRC2 | 24/07/2016 | OUTPUT?? |
<tbody>
</tbody>