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
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

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

20 responses