HELP me PLZ

[KOK]

Hello All,
I require help for the following question :
I have data in Sheet1, Row 1,which contains unique data , and this data
scattered in Sheet2, which is also unique.
Now, on Sheet1 , on Row2, I want the address of cell where the cell can
be found in Sheet2.
For eg. On Sheet1 Cell A1 - contains value - 100, and it can be found on
Sheet2 at c55, now I want this cell reference on Sheet1, B1.

Thanks in Advance..!!

 

[KOK]

Ok I put the Next staement down and got things worked.... you are great ...!!!

Thank you so much ...!!