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
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

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

20 responses