If we want use excel to get the value F.
|
1 2 |
F = A * B * C * D * E |
The common method is using the upper mathematical formulas. But if we adjust the columns, we may get the wrong value because there are some exceptions in the reference columns. So if we can use E to find the location of A or B, this problems are not exit. If E’s location is W7.
|
1 2 |
W7 = LOOKUP(2,1/($H$5:$H7<>""),$H$5:$H7) * LOOKUP(2,1/($M$5:$M7<>""),$M$5:$M7),$P7,S7) * P7 * R7 |