Handle with combined cell

Original link:current page

Description:

No usage information.

One overtime night, a colleague asked me for help to resolve the problem that in excel calculate a result with a combined cell value.
e.g.

the value in red frame is the result as the product of the first column and the second column.

the key is the LOOKUP function
the formula is.

=A5*LOOKUP(1, 1/(B3:B5<>0), B3:B5)

it found the cell rang in B3:B5 and get the value that is not 0.


  • Last modified: 2019/11/06 10:48