I have a CHOP that outputs numerical values. I need to map these numerical values to corresponding strings from a table, where the first column contains threshold numbers, and the second column contains the corresponding strings. For example:
- If the CHOP value is between 2 and 81, I want to return ‘APPLE.’
- If the value is between 82 and 188, I want to return ‘BANANA.’
- If the value is 189 or higher, I want to return ‘STRAWBERRY.’
In other words, the output should match the string associated with the highest threshold that the value does not exceed.