About referencing cells from another sheet.

[tempef]

Hello,

I am currently using this :

Please Login or Register  to view this content.

Now, both the sheet name and the cell coordinates can change (especially the cell. The sheet name is less of an issue), and I would like to replace "Sheet23" by a local cell, and the same for "E369".

So I would end up with something like :

Please Login or Register  to view this content.

I have tried using the INDIRECT function but i can't get anything working. Then I ran out of ideas

Any help is welcome! Thanks

[kvsrinivasamurthy]

Try this
=CELL("contents",INDIRECT("'"&F8&"'!"&F9))