Previous Topic Next Topic

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


Related:

1 response

Answer 1 / 1
RayH
Jan 15, 2015 at 03:47 PM
Take out the brackets:

='A2'!C3

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses