Apply a formula Based on lookup cell

Hey everyone,
I would really appreciate your help solving this challenge.
I have a calculation sheet, where the terms of the calculation are specified, and another sheet with the data on which the calculation is supposed to done upon.
I need a formula that can lookup the value in the calculation sheet and apply the formula on the data sheet.
thanx for your help,
Shirroco

Hi,

To avoid overcomplicated composite formulae which would involve either OFFSET() or INDIRECT() functions, the attached with some helper columns is I suggest preferable.

Hi, I had a closer look on the workbook and there is discrepancy between what you shown in yellow cell in Data Sheet and in column G in Calculation Sheet.
Assumning yellow cell is right, you can use a bit long, but simple formula:

Please Login or Register  to view this content.

which as a matter of fact consists of 3 very similar parts:

Please Login or Register  to view this content.

number of square meters in given range is multiplied by respective value from column C-E from row where Area matches.