Search for a particular variable in Excel and get the value in the other column of the same data row

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.
image

@ashok.p

  1. Use Read Range activity to read the data from Excel file and will give you output as Datatable and say DT.

  2. 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.