Hi, i really need your help, it’s been two days now since i try to fix this bug but no success. I’m working with Vlookup in ui path studio to do some excel process but still getting this error message :
24.2.1-beta.15932+Branch.release-v24.2.1.Sha.3f90483a69af341308fcab9ad25ddc1395738901.3f90483a69af341308fcab9ad25ddc1395738901
Source: VLookup
Message: TypeConverter cannot convert from System.String.
Exception Type: System.NotSupportedException
Really need your help
Hi,
Can you please share the vlook up scenario with input file. I will share the xaml file with you. We can use linq here.
Thanks
students1.xlsx (10,6 Ko)
This is the excel workbook that i’m working with and the scenario is to automate a vlookup process that will look for the value in the field “Course” of the excel workbook in the sheet “students”, in the range of sheet “Courses” of the same workbook then save the value in the field “course Name” of the sheet “students” of the excel workbook.
Find more details in those pictures below:
Can you try the below
"=VLOOKUP(D2,Courses!A:B,2,0)"
Input:
Output:
students1.xlsx (11.0 KB)
Cheers!
