LookUp (Match)
This function returns the ReturnValue in the lookup table whose LookUpValue equals to SourceSymbol value.
Syntax:
LOOKUP ("Match","Table",SourceSymName)
where:
- Match is the name of the lookup method.
- Table is the name of an ASCII file containing the table of values to be referenced by the LookUp function.
- SourceSymName is a symbol in the dimension specifying the criteria for selection.
Table format
LookUpValue @ ReturnValue
All LookUp values must be numeric.
Example table
10 @ 110
11 @ 200.50
222 @ FOUND1
12 @ 130
13 @ 140
11 @ 333.01
15 @ 150
16 @ 50.25
11 @ 100.25
222 @ FOUND2
Syntax example:
SALES1=LOOKUP("Match",LookupTable.txt,SALES2)
If the LookupTable file contains the entries shown above and SALES2 contains 222, the value returned is "FOUND1" and this is assigned to SALES1. Match finds the first entry in the table that matches.