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

[papulepooja (Human Robo)]

Hi,

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

[abdullahtayhan]

Hi @papulepooja, Welcome to Community
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

[YAZIDI (YAZIDI Abdelhadi)]

Hi @papulepooja and welcome

You can use LookUp Range.

Cheers