@singh_sumit
Hi Sumit
I tried your solution too. It’s working fine but in expected output the bot is writing the complete text instead of a value.
Regards
Naman
@aronama ok so what you want to write in the output could you share the screenshot or write in the comment so i could give the logic …
cheers
As shown in the screenshot, the ‘Value’ column contains multiple entries. I want the bot to check if any value from column ‘C’ appears in the ‘Text’ column, and if so, write that value in the ‘Expected Output’ column.
@aronama in my opinion you told you have to compare 2 column and write the text from column 2 to column 4 but how you tell bot to pic this specific word .because there no fixed position no fixed index or something to make logic for this … so how you could tell bot to pic only this word?