The Pair function transfers values from one cell to another. It is typically used in conjunction with the PairGroup function. Values are transferred upon a designated Interject event (e.g. a drill or as defined in the function it is embedded in). It is best practice to use the PairGroup function even when only entering one Pair.
This function will transfer one cell value in B22:B24 to the Target. The particular cell it will transfer is determined by which cell is selected when the function is triggered. If the active cell is in row 22, then the value in B22 will be transferred.
The value in From will be transferred to cell C23 of the sheet “CustomerOrderHistory”.