Function Summary
Used to specify a from value that will be passed to a target area in a new sheet. Used with PairGroup() () for sheets that are in the same workbook.
Function Arguments
|
Parameter Name
|
Description
|
Default
|
Optional
|
|---|---|---|---|
|
From |
Enter a range or string that describes what will be copied from into the specified target |
|
NO |
| Target | Enter a range or string related to a target cell that will recieve the values specified in the From parameter. |
|
NO |
| RequireValue | Enter a True or False to indicate if the From value is required to exist in the data. | TRUE | YES |
| ScopeRange | This will limit the pair to only be used when the user is selected in the entered range. |
|
YES |
Function Composition
|
Formula
|
Example
|
Explanation
|
|---|---|---|
|
=Pair( From ,Target ,RequireValue ,ScopeRange ) |
= ReportDrill ( Drill_Order!B2 , ,PairGroup ( Pair ( F13:F14 , Drill_Order!H7 , TRUE ) ) , "Open Order Page" ) |
← Pair function embedded in ReportDrill and PairGroup formula. This example accepts a single pair. ← From Range. This is range is context that will be brought into the target cell. ← Target sheet and cell ← The Required Value parameter is set to True, which requires the From value to exist. |
Function Example
|
From File
|
Worksheet
|
|---|---|
| InterjectBasic | Drill_Orders |