# How to implement VLOOKUP Formula between 2 different excels

Hi!

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.

=IFERROR(VLOOKUP(AP2;‘1SDR 2021 PL ÜRÜN LİSTESİ (BARKOD10) DÜN.xlsx’!\$A:\$AJ;36;0);“E”)

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

Can anyone help me to solve this problem?

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

1 Like

Hi,

Pls use formula like below one:

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

Hi,

Try using workbook activity’s write cell

Thanks

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

Screenshot:-

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

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

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

xlWorksheet.Activate()

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

xlWorksheet.Range(Range+RowsCount.ToString).Formula=ExcelFormula

xlWorkbook.Save
xlWorkbook.Close

Catch ex As Exception
Throw ex
Finally
xlApp.Quit

End Try
``````

I used invoke code activity with VB.net 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.