Okay,
My first worksheet's name (see below image) is "Main", the second sheet in my workbook is named "c01". I want cell E5 in sheet "Main" to always have the same value as cell C23 of worksheet "c01". So I use the following function:
='c01'!C23
which works great. My question is this; How can I rewrite the function above a little so that I'm not statically telling that cell which worksheet ("c01" in this case) to reference, but rather to get part (the 01 part) of the name of the worksheet in the cell 3 to the left of itself???
So in other words, something like this:
='c(value of cell three to the left)'!C23
I hope that makes sense. I know there's probably a few ways to do this but so far it's not working. I tried
=INDIRECT("'c"&B5&"'!23")
but it didn't work.
-- removed inline image ---
Thanks in advance...
DeR
My first worksheet's name (see below image) is "Main", the second sheet in my workbook is named "c01". I want cell E5 in sheet "Main" to always have the same value as cell C23 of worksheet "c01". So I use the following function:
='c01'!C23
which works great. My question is this; How can I rewrite the function above a little so that I'm not statically telling that cell which worksheet ("c01" in this case) to reference, but rather to get part (the 01 part) of the name of the worksheet in the cell 3 to the left of itself???
So in other words, something like this:
='c(value of cell three to the left)'!C23
I hope that makes sense. I know there's probably a few ways to do this but so far it's not working. I tried
=INDIRECT("'c"&B5&"'!23")
but it didn't work.
-- removed inline image ---
Thanks in advance...
DeR
Last edited: