P
PCLIVE
Well I figured the simple part of this formula formula. However, I'm having
trouble fitting
it into a larger scale formula. The simple part is to reference a Worksheet
name based on a cells contents. I want to reference "Sheet" & the number
which resides in cell AH1. The formula below seems to do it.
="Sheet"& ROW(INDIRECT(AH1&":"&$AH$1))
I'm not sure if that is proper method, but it seems to work.
Now I need to fit that into a larger formula, but I'm having trouble. Here
is the current formula.
=RIGHT('Sheet1'!A1,(LEN('Sheet1'!A1)-(LEN(AF1)+40)))
Where it shows "Sheet1", I need to fit in the Indirect formula that I listed
above.
Any ideas?
Thanks,
Paul
trouble fitting
it into a larger scale formula. The simple part is to reference a Worksheet
name based on a cells contents. I want to reference "Sheet" & the number
which resides in cell AH1. The formula below seems to do it.
="Sheet"& ROW(INDIRECT(AH1&":"&$AH$1))
I'm not sure if that is proper method, but it seems to work.
Now I need to fit that into a larger formula, but I'm having trouble. Here
is the current formula.
=RIGHT('Sheet1'!A1,(LEN('Sheet1'!A1)-(LEN(AF1)+40)))
Where it shows "Sheet1", I need to fit in the Indirect formula that I listed
above.
Any ideas?
Thanks,
Paul