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.