Is there a way to go to a cell in another worksheet that has an identical
value of a cell in another worksheet? Example:

Current cell location: worksheet1.A1

Reference cell location: worksheet1.A2

Cell to go to: worksheet2.[same data that is located in worksheet1.A1]

Any help with this is greatly appreciated. Thanks.

G