Trying to add 2 formulas together in a cell

[arekkusu03]

Hi Guys. Im trying to get this formula =INDIRECT("'"&A1&"'!INDIRECT(CHAR(COLUMN(C1)+64)&COLUMN(E1)")
translate to ="Monday!C5" so it can reference Monday sheet

A2 =Monday!C5
A3 =INDIRECT("'"&B1&"'!C5")

Ive have used this which = CHAR(COLUMN(C1)+64)&COLUMN(E1) = "C5"

and =INDIRECT(CHAR(COLUMN(C1)+64)&COLUMN(E1)) = Reference cell C5

Im trying to combine these formulas together with INDIRECT("'"&B1&"'!C5") by doing the follow below

=INDIRECT("'"&A1&"'!CHAR(COLUMN(C1)+64)&COLUMN(E1)") but it comes up with #REF!

Or ive used this also

=INDIRECT("'"&A1&"'!INDIRECT(CHAR(COLUMN(C1)+64)&COLUMN(E1)")

Also comes up with #REF!

Please if anyone can help me that will be greatly appreciated, Ive attached a sample below

Sample1.xlsx

Thank you

[canapone]

Hi,

maybe

Please Login or Register  to view this content.

Hope that helps

[zbor]

Try:

Please Login or Register  to view this content.

[arekkusu03]

Thank you to you both it worked!!!