Vlookup in Excel Using UiPath

Help
1

Hi,

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

1 Like
2

Hi @Ashutosh93

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

cheers :smiley:

Happy learning :smiley:

2 Likes
3

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.

4

Hi Rahul,

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

5

Hi Pattyricarte,

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

1 Like
6

yey that was great @Ashutosh93

cheers :smiley:

Happy learning :smiley:

2 Likes
7

Can you please guide which code is to be pasted in the invoke code activity, I couldn’t find it.