So sorry. Wasn't thinking when I called that column 'C1'. I know better. Lets say it's named 'wacadoo'. Then, I need a formula something like:
[CODE]
=Indirect("'" & sname & "'!R" & rNum & "C" & Column(COLUMN(INDIRECT("'"&sName&"'!wacadoo"))
/[CODE]

That formula, however, gives me an error.

In other words, the column number for the named range 'wacadoo' is different on sheets 'S2' and 'S3'. I need to get the value on sheet(sName) at row(rNum) on column 'wacadoo'. 'sName', 'rNum' values on stored on sheet 'S1'.

Sorry if I'm not making this clearer.

Thanks.