compare value of each cell in one column with the values in other column to find the match

[Veni_Padam]

Hi,
Input:

output:

 Ques - 1.compare Num_2 with Num_1 for the match case
               2.if it matches then check the value in Comment_1 column for that Num_1 value
               3a.if value is null in Comment_1, then update as "No data" in Comment_2 for the respective Num_2.
               3b.If value is not null in Comment_1, leave as it is.
example:
Num_2=789
search for 789 in Num_1 and then check the value of Comment_1 
value is null in Comment_1, so updated as "No data" in Comment_2 for Num_2=789

Thanks inAdvance!
                             

[atcodedog05 · Accepted solution]

Hi @Veni_Padam 

Here is how you can do it.

Workflow:

Hope this helps : )

[Veni_Padam]

yes:) - Thank you very much!

[atcodedog05]

Happy to help : ) @Veni_Padam 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!