Return Cell Address if text found anywhere

WS_Chai · August 25, 2023, 8:36am

Hello there,

I have a workflow which finds a text (2021 or FY21) in every sheet of an excel.
If either one text is identified anywhere in the sheet, the bot is supposed to write the cell address to me.

The bot is working however, the bot only highlights the cell address to me if the cell content is “2021” or “FY21” (standalone with no other text). If it appears as a sentence or date format in a cell, the bot fails to highlight the cell address.

How do I rectify my flow so that I can locate the text everywhere within a sheet?

Quenton_Wayne_Rebello · August 25, 2023, 9:15am

Hey can you show me your properties of the lookup range you are using and the excel activity package version, since on using lookup range this output i have obtained,