I am doing a lookup in a Data Table like this by using an Assign activity.
columnFilteredZMRDT.Rows(3).ItemArray.ToList.FindIndex(Function ( c ) c.ToString.Equals(lookupBewohner))
“lookupBewohner” is a String I pass. Despite this String is just exactly as it is in the Data Table (made an export to Excel to check), the returned value is -1, which means it does not exist.
@BOTFORCE
I would suggest to bring the bot into debug and Breakpoint mode. then test is part by part within the watch or immediate box. as it comes from excel also include some trim statements