Hi,
In Sheet2,Cell E2 , I am using Sheet1!E2.

But i am not getting the result. It is displaying as =Sheet1!E2 (as text
entry)

I don't know what wrong with this formula.

Please help in this regard.

Best Regards,