Interject Documentation > Pair()
Estimated reading time: 1 minuteFunction 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 ](/wIndex/81756186.html) 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 |