Excel cell formula query

Hi, I am reading data from the first cell.
This is my Test file
image

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
image

How I am writing
image
It shows the something wrong in the formula. can you correct me.

@HareeshMR @Palaniyappan @Shubham_Varshney

2 Likes

@balkishan In write cell use double quotes for formula

2 Likes

image

1 Like

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”")"

1 Like

It executed but not written any status in A2.
image

image

It written the formula here not the Match/ No Match status.
image

1 Like

@Lahiru.Fernando @HareeshMR please see this issue…

1 Like

Simply assign the formula to a variable of type string and give it in the write cell activity bro @balkishan,

That will work

2 Likes

didn’t worked bro. It write the formula in the cell

image

1 Like

Try to write that formula in another cell except A2 and B2 bro :slight_smile:

2 Likes

I want write the Match/ No Match status in the cell bro. once it compare the cell values.

1 Like

You mean comparing two excels and write the status in third excel right or in the same excel? @balkishan

2 Likes

Yes, I am reading the data from two excel and comparing it and write the status in another excel.

1 Like

@balkishan You are reading excel from Test.xlsx and Comparing with TestWritten.xlsx so you are getting empty.

2 Likes

So, try the formula manually once @balkishan, Then assign it to a variable and then run the process. It will work for sure :slight_smile: … If you want to test the above formula, try to write in C or D columns so that it will display the output

2 Likes

Bro simply do update write cell on C column, copy the column in end and paste is in other excel!!!

1 Like

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.
image

@Shubham_Varshney @HareeshMR

1 Like

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”)

2 Likes

manually it’s working bro

1 Like

@balkishan

If file is not opened…

Then you have to mention Excel File path before formula…

2 Likes

Use same formula in the workflow also @balkishan :slight_smile:

2 Likes