Pairwise lifting occurs when values in two or more arrays are combined pairwise to produce a different array holding the result of this operation.
Example
The example shown illustrates what happens if you call the SQRT function like this: Inside SQRT, two vertical arrays are added together with the addition symbol. The values in these arrays are combined pairwise, and result of this operation is a single array with 3 values: The SQRT function does not handle arrays natively, so the function is “lifted” and called three times, one for each value. The final result in an array with three values:
Handling with multiple results
When lifting occurs in a formula, there will be multiple results, and these need to handled in some way. One approach is to return all values to a worksheet in a multi-cell array formula. Alternatively, you can pass the result into another function like SUMPRODUCT: to return a final result of 9. SUMPRODUCT will handle arrays natively, so this formula does not require control + shift + enter. The SUM function could be used as well, but would need to be entered with CSE. Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
