Hi,
I am trying to search for a variable in Excel and if found, need to get the value in the other column corresponding to the same datarow.
For Example, If I have 3 columns A, B ,C in an excel. I have to search for 50 (In column B) and need to fetch the the value in column āCā(i.e 25)
can some one please help.
Search for a particular variable in Excel and get the value in the other column of the same data row
-
Use Read Range activity to read the data from Excel file and will give you output as Datatable and say DT.
-
And then use For Each Row activity to iterate that Datatable DT.
ForEach row in DT
If row(1).ToString = ā50ā
Then print row(2).ToString
Else skip it.
2 Likes
hi,
this works, thanks
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.