2 Replies Latest reply on Jan 27, 2017 9:15 AM by paolo.raia

    Using Lookup/Last to auto-complete NULL values ?

    paolo.raia

      Hi there,

       

      I have the following table:-

      I need to populate the Nulls with the corresponding value for that Code.

       

      For example, the Null in code CC needs to be populated with "Example3" and so on.

       

      Have to also take into consideration a Null without a corresponding value, i.e. Code EE.

       

      I have tried Lookup and Last etc, but these only seem to want to work with numerical values.

       

      Many thanks in advance.