The term "pairwise lifting" in Excel refers to a special case of "lifting" – a built in calculation behavior whereby functions that don't handle arrays natively are "lifted" and called once for each value in an array, returning in turn an array containing multiple results.
Pairwise lifting occurs when values in two or more arrays are combined pairwise to produce a different array holding the result of this operation.
The example shown illustrates what happens if you call the SQRT function like this:
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:
An array in Excel is a structure that holds a collection of values. Arrays can be mapped perfectly to ranges in a spreadsheet, which is why they are so important in Excel. All Excel formulas that use a worksheet reference are working with arrays. In...
The term "lifting" refers to an array calculation behavior in Excel formulas. When you give an array to a function not programmed to accept arrays natively, Excel will "lift" the function and call it multiple times, one time for each value in the...