VLOOKUP, IF, Return Formula

[ir_dosh]

Hello,

This is my first post and I apologize if this has been addressed before. I need a formula where
Cell A1= a value in Column 1, AND
Cell B1 = a formula in Column 2, which

return a formula/value in Column 3 in cell C1.

Column 2 is a range. The objective here is to get the corresponding formula in Column 3 given the value in Column 1 that meets the formula in Column 2. I was thinking a combination of VLOOKUP, IF, AND, <, =< functions in the formula.

I have split the formula in Column 2 and Column 3 into two values/variables to kind of simplify the formula that I want to build. Appreciate help/response from the forumers. File attached. Thanking you in advance.

[#2 · Accepted solution]

@ir_dosh 

That could be

=SUMPRODUCT(($E$7:$E$29=K7)*(L7>$F$7:$F$29)*(L7<=$G$7:$G$29)*$H$7:$H$29)

and

=SUMPRODUCT(($E$7:$E$29=K7)*(L7>$F$7:$F$29)*(L7<=$G$7:$G$29)*$I$7:$I$29)