String formula with variables on one sheet

Question

I am relatively new to formulating formulas, so I don’t know how best to approach this, or add it in order to find a good answer through a search.

I have the following data:

I want to take the formula row contained in column E for each row, replace the variables with the data that is on the same row, and evaluate the expression. I have no idea if this is possible, but I am ready to try VB Macros or something else.

Using the above thinking:
   B8 = SUM (4 + (8/2))
   B9 = SUM (5 + (6/2))
   C8 = SUM (5 + (6/2))
   , etc ...

, - . , . .

Answer 1

, .

, A \ " "

8 9

, , , , , ... , , Define name .

Answer 2

, Vlookup, , .

( , , . ):

():

=SUM(VLOOKUP("Az",$A$2:$D$6,column(),FALSE)+(VLOOKUP("Cx",$A$2:$D$6,column(),FALSE)/2)) =SUM(VLOOKUP("By",$A$2:$D$6,column(),FALSE)+(VLOOKUP("Ev",$A$2:$D$6,column(),FALSE)/VLOOKUP("Dw",$A$2:$D$6,column(),FALSE)))

... .

, , , , , , , ( 11 12) F, G H :

=SUM(VLOOKUP($F$11,$A$2:$D$6,COLUMN(),FALSE)+(VLOOKUP($G$11,$A$2:$D$6,COLUMN(),FALSE)/2))
=SUM(VLOOKUP($F$12,$A$2:$D$6,COLUMN(),FALSE)+(VLOOKUP($G$12,$A$2:$D$6,COLUMN(),FALSE)/VLOOKUP($H$12,$A$2:$D$6,COLUMN(),FALSE)))

, ? , , , indirect() ro use E8 E9 , , , ...

. "" , , , E8 E9, . ( ), B8 =SUM(VLOOKUP(MID($E$8,SEARCH("(",$E$8)+1,2),$A$2:$D$6,COLUMN(),FALSE)+(VLOOKUP(MID($E$8,SEARCH("+(",$E$8)+2,2),$A$2:$D$6,COLUMN(),FALSE)/2))

B9, =SUM(VLOOKUP(MID($E$9,SEARCH("(",$E$9)+1,2),$A$2:$D$6,COLUMN(),FALSE)+(VLOOKUP(MID($E$9,SEARCH("+(",$E$9)+2,2),$A$2:$D$6,COLUMN(),FALSE)/VLOOKUP(MID($E$9,SEARCH("/",$E$9)+1,2),$A$2:$D$6,COLUMN(),FALSE)))

, , Sum(Cx+(Ev/2)) , , E8 , answer1 B8 .