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!
Solved! Go to Solution.
yes:) - Thank you very much!
Happy to help : ) @Veni_Padam
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!