Hi

I like to know how to do this. For eg, If In Sheet1 cell A1, I have a text "Sheet2!B1" and if I want use this data and return the value of the cell in Sheet2 B1 (for eg say 20$), how can I do it?

I tried use "=A1" in sheet1 but I get text in cell A1 i.e "Sheet2!B1" but not its value 20$. though it makes sense not to use this (=A1) i cant figure out how to achieve this.

Thanks in advance for the help..

arkay..