How to implement VLOOKUP Formula between 2 different excels

Help Activities
, ,
1

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?

2

Hi @Betul_Dundar ,

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

1 Like
3

Hi,

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.

2 Likes
4

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.

5

Hi,

Try using workbook activity’s write cell

Thanks

6

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

Screenshot:-
image

image
image1162×207 13 KB

Hope this might help you :slight_smile:

7

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

8

Hi @Betul_Dundar ,

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

9

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

10 
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:

image
image867×263 12.4 KB

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
11

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