Hi, I am reading data from the first cell.
This is my Test file
And compare the data of A2 with B2. If match/unmatched wants to write the status into another excel. Matched/Not Matched
see this is the second excel where write the status in A2
How I am writing
It shows the something wrong in the formula. can you correct me.
@balkishan In write cell use double quotes for formula
The formula needs to add " in start and end and as well before any " add a quote " in start
So example:
“=If(A2=B2,”“Match”“,”“No Match”“)”
It executed but not written any status in A2.
It written the formula here not the Match/ No Match status.
@Lahiru.Fernando @HareeshMR please see this issue…
Simply assign the formula to a variable of type string and give it in the write cell activity bro @balkishan,
That will work
didn’t worked bro. It write the formula in the cell
Try to write that formula in another cell except A2 and B2 bro 
I want write the Match/ No Match status in the cell bro. once it compare the cell values.
You mean comparing two excels and write the status in third excel right or in the same excel? @balkishan
Yes, I am reading the data from two excel and comparing it and write the status in another excel.
@balkishan You are reading excel from Test.xlsx and Comparing with TestWritten.xlsx so you are getting empty.
So, try the formula manually once @balkishan, Then assign it to a variable and then run the process. It will work for sure … If you want to test the above formula, try to write in C or D columns so that it will display the output
Bro simply do update write cell on C column, copy the column in end and paste is in other excel!!!
see, Here I have a Test1 and Test2 files where I am reading the data.
and write into Status file.
I am comparing the each cell value.
This will be the formula in your case @balkishan
Try assigning this to a variable and pass it to write cell
=IF([Test1.xlsx]Sheet1!$A$2=[Test2.xlsx]Sheet1!$A$2,“Matched”,“NotMatched”)
manually it’s working bro
Use same formula in the workflow also @balkishan