Lookup
      Back to home
      1. Help Center
      2. Operations
      3. Lookup

      DLOOKUP Operation

      How to use the DLOOKUP operation in formulas

      Definition

      Example 

      Syntax Guide

       


      Definition

      The DLOOKUP operation is similar to the VLOOKUP you will find in Excel, except it requires a dictionary. DLOOKUP will replace values based on that dictionary. 

       

      Example

      DLOOKUP($ATT.COLOR, {"red": "rojo","blue": "azul"},"not defined")

      $ATT.COLOR value: red
      Result: rojo

       

      Syntax Guide

      DLOOKUP(value, dictionary, [default])

      value - The value to replace

      dictionary - A set of keys and their corresponding values for replacement enclosed in brackets

      default - [ OPTIONAL ] - When no value is found, this defines the default value

       

       

      What's Next