Formula to referance Sheet

Hello:

Please refer to attached sheet.
I have excel workbook with monthly Sheet and YTD Sheet.

In YTD, Row 3 has names of sheets (Monthly Sheets).
I need a formula in cell C5:E5 to reference monthly sheet and want to use the name of the sheet in row 3.
I am adding formula c5 = 'C3'!C5 and it is giving error.
FYI : i know i can use c5 = Jan13!C5 but i do not want to use this method.

Please help me setup this formula to use name reference from cell C3:E3.

Thank you and let me if any questions.

Riz Momin

Try this:

Please Login or Register  to view this content.

You can drag it across =INDIRECT(C3&"!C5")
you can drag it down but you need to have sheet names in C4, C5 and so on.

But if you need to drag it down and across try to use this:

=INDIRECT(C$3&"!"&CHAR(64+COLUMNS(A:A)+2)&ROW(5:5))

You're Welcome and thank you for you feedback!

Another way:
I think a little bit quicker:
=INDIRECT(C$3&"!"&CELL("address",$C5))