Find the cell value

I know to column name in the excel
But I want to know in which cell range it exists?
Can anyone help me in finding it?

u can use the below code:


Dt1 is Your datatableName

assign this to one string variable.

Thanks and Regards,

I don’t understand your requirement @Sweety_Girl… Can you explain :slight_smile:

I have 5 column
Aaa will be in A cell range
bbb will be in B cell range

if the column order changes, I need the cell range
How to get it

use Lookup Range activity


1 Like

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