AnsweredAssumed Answered

Lookup on multiple oolumns

Question asked by on Nov 17, 2016
Latest reply on Dec 8, 2016 by



I have a list with three columns: "Impact","Likelihood","Risk".  I also have a form where the users select the impact and likelihood and the form should then calculate the risk (based on this list).


I am trying to use the form runtime function lookup() , but this can only filter on 1 column, so I was thinking of nesting this somehow.  I can not find how to do that, though, as the input only allows a single value.  Would anybody know how to do this?