I am having a problem, which I did not manage to solve via other threads on this forum, so I hope someone can help me.
In the attached file I am looking for the price of a material (column A) based on the entry date.
So the formula first needs to check which Material is related (column E) and then in which date range it falls (columns F & G) and then returns the price (column H).
I was not able to create an unique value to create a VLOOKUP, I also had a look at INDEX/MATCH and SUMPRODUCTS, but without much success.
The final data will be over a large amount of lines.
Any help would be appreciated.
Bookmarks