How to get a value from excel row without mentioning column name?

Hi team ,

I want to search which row contains the word - “hello”. I dont want to use row(“columnname”).tostring.contains logic here.Is there another way to fetch this .
The word would always be in column A


Thanks,
Gokul

Hi @gokul1904 ,

The lookup value can be used in the column 0 . It returns the row index and Row value.

1 Like

Hi,

How about LookUpRange Activity as the following?

This returns address of matched cell.

Regards,

Thank you !!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.