attached an example file, i need help in vlookup formula or any other way to look up values in between dates
For example if abc purchased on dated: 01-01-19, its next buying date is 01-02-19, so in betwen these two dates whatever dates are, the price lookup should show price on 01-01-19.
If last buying is on 01-04-19, and no record after that, it should lookup that last figure on all afterwards date
For example if abc purchased on dated: 01-01-19, its next buying date is 01-02-19, so in betwen these two dates whatever dates are, the price lookup should show price on 01-01-19.
If last buying is on 01-04-19, and no record after that, it should lookup that last figure on all afterwards date