Vlookup in Excel Using UiPath

Hi,

Can anyone advise on how to use Vlookup in Excel using UiPath

1 Like

Hi @Ashutosh93

I hope this article might be helpful to you.
check this out.

cheers :smiley:

Happy learning :smiley:

2 Likes

Hi @Ashutosh93,

I also face the same problem in one of my project.

  1. Try using invoke code activity and you can download the c# code from google. Please find the below link and paste the code in the invoke code activity.

  2. Use below formula in the write cell activity.
    Formula1 = “=iferror(VLOOKUP($J2,‘ExcelSheet’!$A:$G,2,0),”""")"
    Formula1.Replace(“ExcelSheet”,“BF Raw Splunk Update”)

Use your “SheetName” and Cells on which you want to apply Vlookup.

Hi Rahul,

Thank you for providing the solution. I was able to implement Vlookup using point 2.

Hi Pattyricarte,

Thank you for providing the solution. I was able to implement Vlookup in UiPath

1 Like

yey that was great @Ashutosh93

cheers :smiley:

Happy learning :smiley:

2 Likes