Lookup tries to find a value in a list of values and returns the list position: LOOKUP(value,list of values)
For example, LOOKUP(12, 5, 4, 1, 12, 56,72) returns 4



Reference the image above, the full function used is: |LOOKUP(audience.sender.max_bond,audience.sender.one,audience.sender.two,audience.sender.three, audience.sender.four)|