on the SP tab I have Short Period (Column A) and corresponding Survivor Entity (Column E)
on tab 7171000 I have the Entity Code column (Col A)
Here is what I am trying to achieve -
If the Short Period and the Corresponding Survivor entity, both exist in Entity code then both should be populated in column K and L
if only one of them exists then it should be populated and the other value should be left blank.
Please advise how can I create this work flow.
