How to implement VLOOKUP Formula between 2 different excels


I have a 2 excels. I can’t use read range activities because data is too big. I have a formula but, I don’t know how to implement this formula within Excel Application Scope Write Cell.


1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx: My second excel.

Can anyone help me to solve this problem?

Hi @Betul_Dundar ,

Can you share 2 sample files so that we can check on and provide you with the solution?

1 Like


Pls use formula like below one:

=IFERROR(VLOOKUP(A2,[2nd_Excel_Path]Sheet_Name!$A:$A,1,FALSE),“NOT FOUND”)

  • you need to pass path of second excel in square bracket followed by sheet name then exclamatory mark and then range
  • Also pass TRUE or FALSE not 0 or 1

Mark it as solution if it solves your issue.

1 Like

Hi Kalpesh! Thanks your advice but it gives me an error like this:

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=IFERROR(VLOOKUP(AP2,[C:\Users\dev\Desktop\1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx]1SDR 2021 PL ÜRÜN LİSTESİ (BARK!$A:$AJ,36,FALSE),“NOT FOUND”)” has a wrong format;
► Excel is busy or you are currently editing a cell;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.


Try using workbook activity’s write cell


Hi @Betul_Dundar ,

Check this below Vlookup formula its working for me,
"=IFERROR(VLOOKUP(AP2,'C:\Users\....\Downloads\1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx'!$A:$AJ,36,FALSE),""Not Found"")"

"=IFERROR(VLOOKUP(AP2,'C:\Users\....\Downloads\1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx'!$A:$AJ,36,FALSE),""E"")"


Hope this might help you :slight_smile:

If I use excel write cell activity, same error as i mentioned before. Also, I tried workbook write cell activity.
Gives me an error:

Job stopped with an unexpected exit code: 0xE0434352

RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0xE0434352

Hi @Betul_Dundar ,

Can you send the screenshot of the write cell activity and the formula you used inside the write cell?

Hi @Manish540 , 0xE0434352 error is reason being huge data.

Dim xlApp As Microsoft.Office.Interop.Excel.Application = New Microsoft.Office.Interop.Excel.ApplicationClass

	Dim xlWorkbook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Open(Path)

	Dim xlWorksheet As Microsoft.Office.Interop.Excel.Worksheet
	xlWorksheet = CType(xlWorkbook.Sheets(sheetName),Microsoft.Office.Interop.Excel.Worksheet)


  	Dim RowsCount As Int32 = xlWorksheet.UsedRange.Rows.Count



Catch ex As Exception
	Throw ex
End Try

I used invoke code activity with code . You can find my arguments below:

I used this Formula: “=IFERROR(VLOOKUP(AP2,‘C:\Users.…\Desktop\1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx’!$A:$AJ,36,FALSE),”“E”“)”

Thanks for your advices. You helped me a lot finding right excel formula. @Manish540 @Kalpesh_Chaudhari

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.