1 Reply Latest reply: May 15, 2014 9:53 AM by RalphB _ RSS

    Multiple field lookup

    John_R _

      Is it possible in a calculated field to design a lookup that uses multiple criteria (multiple input fields)?  Something similar to an array function or database function in Excel? 



        • Multiple field lookup
          RalphB _

          John welcome to the forum.


          You don't state which version of Monarch you are using. If you are using Monarch V6Pro or newer you can use the External Lookup feature.  You can find that on the Table tab under "Data".  You can link to either speadsheets or databases with this.  It is similar to the VLookup function in Excel.