How to search a string in an excel when a row number is known?


I have an excel with dates and average data for each column. The date is not a column name. I have a date stored in a variable and need to find the column index using the row number and the string(cell value).

Hi @papulepooja, Welcome to Community :slight_smile:
If you know your row index, you could get that specific row as ObjectArray (dt.rows(rowindex).ItemArray)
Then use foreach activity in that array, use If-Else for searching and get index of count.

Cheers :slight_smile:

Hi @papulepooja and welcome

You can use LookUp Range.

Cheers :upside_down_face: