Hi friend,

1) In cell A1 of sheet 2, enter the formula as =Sheet1!A1

2) Not sure about this. Are you looking to match full text or partial text ?

Regards,
DILIPandey