Find specific words in one single column in excel

[Hendry_Nicholas]

Hello guys
new to Uipath here
i wanna ask is there a way for me to find specific keywords from one column in excel?
a direction would be appreciated
TIA!

[Krishna_C]

@Hendry_Nicholas

Check the screenshot below.

Is it what you’re looking for?

Regards,
Krishna

[TimK (Tim Kok)]

You can use datatable.select

I.e.

Datatable.select(column1=‘ABC’)

This will return all rows in an array where column 1 equals ABC

[Arpit_Kesharwani]

@Hendry_Nicholas Use lookup Range activity and provide your keyword and the column range. If found it will give you a cell address otherwise return null

[Hendry_Nicholas]

I don’t think this is it but it’s worth trying
thanks for the advice!

[Hendry_Nicholas]

noted
thank you!

[Hendry_Nicholas]

Will try
thanks!