Hi,
l find first variable from the table with vlookup formula and l bump with second variable. In this way, 15 lines continues one under. At the end, l take sum of the results.
The following formula can do this process, but my other tables has more than 15 lines. Can we solve this with a short formula?
=DÜŞEYARA(B3;$E$3:$F$23;2;0)*C3+DÜŞEYARA(B4;$E$3:$F$23;2;0)*C4+DÜŞEYARA(B5;$E$3:$F$23;2;0)*C5+DÜŞEYARA(B6;$E$3:$F$23;2;0)*C6+DÜŞEYARA(B7;$E$3:$F$23;2;0)*C7+DÜŞEYARA(B8;$E$3:$F$23;2;0)*C8+DÜŞEYARA(B9;$E$3:$F$23;2;0)*C9+DÜŞEYARA(B10;$E$3:$F$23;2;0)*C10+DÜŞEYARA(B11;$E$3:$F$23;2;0)*C11+DÜŞEYARA(B12;$E$3:$F$23;2;0)*C12+DÜŞEYARA(B13;$E$3:$F$23;2;0)*C13+DÜŞEYARA(B14;$E$3:$F$23;2;0)*C14+DÜŞEYARA(B15;$E$3:$F$23;2;0)*C15+DÜŞEYARA(B16;$E$3:$F$23;2;0)*C16+DÜŞEYARA(B17;$E$3:$F$23;2;0)*C17
The sample file is attached.
Regards.
Sorry my language.
Thank you for your help.
Bookmarks