Useing (='sheet'!cell) if the sheet name is depending on cell

Closed
amj - Jan 14, 2015 at 08:25 PM
 RayH - Jan 15, 2015 at 03:47 PM
Hello,

how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3

='sheet1'!C3 is working, but the sheet name is depending on A2

i got an error if i type (='A2'!C3) is there another way for it?

thank you


1 reply

Take out the brackets:

='A2'!C3
0