I’m at my wits end here. I am making a program that will gather some names into an excel sheet and then search a much larger excel sheet for the names. I have done this with other uipath bots and have had 0 issue with it. I can’t figure out what I am doing wrong this time, when it seems like I’m doing the exact same thing I always do.
So the section in question is this:
whenever I run the program, the output returns a null value. The names are all in column A and it should definitely find a name in the range I am searching.
I have a write line just below it that has the following: "name substring searched = "+name.Substring(0,name.length-4) and this produces the correct information every time.
if I change the lookup range to “Doe, Jo” instead of name.Substring(0,name.length-4) it will find John Doe’s name in the excel file. however even though name.Substring(0,name.length-4) is “Doe, Jo” i get a null ouput when I run the bot. what am I doing wrong? I use lookup range all the time, and I can’t figure out why its not working this time.
Any ideas would be greatly appreicated!