Populate a field by looking up values in another CAS file (the 'Lookup file'). The first field in the lookup file defines the left axis (must be text). The subsequent field names define the right axis.
lookup 'C:\LOOKUP\BUY\DOWN.CAS' RATERANGE TERMRANGE
lookup2d FileName LeftAxis RightAxis
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| ResultNotField | Text | Field, Constant | Result if field doesn't Exist | No | |
| LeftAxis | Text | Field, Constant | No | ||
| RightAxis | Text | Field, Constant | No |
Type: Text