Find the position in excel sheet of Matched Value

Suppose I have 2 sheets in the same excel file. (sheet1 and sheet2 )
I want to compare two sheets. If the value of sheets matches,
I want to know the position of the matched value in the other sheet.
(eg: something like “C10” as a result)

Hy @shumagain,

You can use the LookUp Activity, it will return the address of a text in a specific sheet

Check it out:


1 Like

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