Can't work out formula to find the relevant price for a given date.
Col A on attached lists range of products. Col B lists the dates of price raises. Col C lists the relevant price at each increase.
Formula in Col G
{=INDEX($C$1:$C$31, MATCH(E3&F3, $A$1:$A$31&$B$1:$B$31,0))}
should find the price in Col C for the product in Col A matching E3, at the date in Col B that covers the date in F3, but setting it as "exact" match generates an error between dates, and setting it as more or less than generates only the orignal value.
Col J shows how it should work..
Any pointers or solutions accepted gratefully as ever.
Ochimus
Bookmarks