Indirect/Concatenate query
Maybe try
=Indirect(Concatenate("StageName_",ROUND(A30/100,0)))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Fred" wrote in message
oups.com...
I have a multi-sheet spreadsheet and am trying to pick up a named field
(StageName_1 .... n) that is defined on the OverallInfo worksheet. The
numeric suffix depends upon the value of the contents of the Milestone
it is related to
StageName_1 is a named field OverallInfo, E7
StageName_2 is a named field OverallInfo, E17
StageName_3 is a named field OverallInfo, E27
A30 = 100
A57 = 200
A84 = 300 etc
I ended up with the formula
=Indirect(Concatenate("StageName_",(A30/100)
But all I end up with is #REF. I countered this by using
If(IsError(Indirect etc, but that just resulted in a blank or empty
cell instead of the value of StageName_1/2/3 etc.
What am I doing wrong ?
Cheers
Fred
|