LookupSwitch | ||||||||
Data Type: Integer (Optional) | ||||||||
Either an Integer (whole number) or the variable can be omitted. v | ||||||||
Example: 1 | ||||||||
Variable Values | ||||||||
Default(s) | ||||||||
0 | Starting at the top of the InputRange (where the values are highest), the lookup finds the first value that is less than OR equal to the InputValue and returns the corresponding value in the OutputRange. This behaviour is the same as the Excel Lookup function. | |||||||
Switches | ||||||||
0 | Starting at the top of the InputRange (where the values are highest), the lookup finds the first value that is less than OR equal to the InputValue and returns the corresponding value in the OutputRange. This behaviour is the same as the Excel Lookup function. | |||||||
1 | Starting at the top of the InputRange (where the values are highest), the lookup finds the first value that is less than the InputValue and returns the corresponding value in the OutputRange. | |||||||
2 | Starting at the bottom of the InputRange (where the values are lowest), the lookup finds the first value that is greater than or equal to the InputValue and returns the corresponding value in the OutputRange. | |||||||
3 | Starting at the bottom of the InputRange (where the values are lowest), the lookup finds the first value that is greater than the InputValue and returns the corresponding value in the OutputRange. | |||||||
4 | Starting at the bottom of the InputRange (where the values are lowest), the lookup finds the first value that is equal to the InputValue and returns the corresponding value in the OutputRange. | |||||||
5 | Starting at the bottom of the InputRange (where the values are lowest), the lookup finds the first value that is NOT equal to the InputValue and returns the corresponding value in the OutputRange. | |||||||
6 | Starting at the top of the InputRange (where the values are highest), the lookup finds the first value that is equal to the InputValue and returns the corresponding value in the OutputRange. | |||||||
7 | Starting at the top of the InputRange (where the values are highest), the lookup finds the first value that is NOT equal to the InputValue and returns the corresponding value in the OutputRange. | |||||||
8 | Find the nearest |