IF, OFFSET, MATCH or what?

Help needed. I have no idea how (exactly what function to use) to solve that problem that a list do use a range of figures that belongs to the previously used formula.
Example file attached because its not easy to describe the problem.

Thanks in advance