Hello. I've tried and tried but get nothing but #REF errors or incorrect results. Please help. Workbook contains several sheets, call them 'S1', 'S2', 'S3'. Sheets 'S2' and 'S3' each have a named column range, called 'C1'. Sheet 'S1' has 2 columns, named 'sName' and 'rNum'. I need an 'indirect' formula on 'S1' that returns the value on sheet(sName) at row(rNum) in column(C1). Something like:
[QUOTE]
=Indirect("'" & sname & "'!R" & rNum & "C" & Column(COLUMN(INDIRECT("'"&sName&"'!C1")).
/QUOTE]

Thanks.