Hi,
I would like to find a way to look up what the discount was on an item within a table.
Sku 1100748, what was the price back in November 1/19
Below shows it has been marked down 3 times. the price from Aug 1/19 on was $20 (disc_amt).
How can I tell vloookup to look at the price that was in Nov 1/19. This item could have been further reduced after Nov 19, so it needs to look after / before dates.
thanks
I would like to find a way to look up what the discount was on an item within a table.
Sku 1100748, what was the price back in November 1/19
Below shows it has been marked down 3 times. the price from Aug 1/19 on was $20 (disc_amt).
How can I tell vloookup to look at the price that was in Nov 1/19. This item could have been further reduced after Nov 19, so it needs to look after / before dates.
thanks