Temperamental Indirect function

[BigDelGooner]

I have a list of the following values...

Monthly_Returns!$A$138:$A$138
Monthly_Returns!$A$136:$A$138
Monthly_Returns!$A$133:$A$138

However the INDIRECT function only works for the first one on the list.

Any ideas why that might be the case?

 

[tushiroda]

indirect works fine as far as I can tell.

Go into the formual and F9 it and see what you are getting. you get 0s for an empty single cell ($A$138:$A$138 is a single cell). if the reference is for an array, you get the #value. If your indirect includes the entry in the indirect itself, apparently it just shoots out what was fed into indirect as text.

if you process the array, you will then get proper handling of the array such as SUM or whatnot.

 

[BigDelGooner]

Thanks for your help guys, problem now solved.

Tushiroda you were right...when then INDIRECT function was incorporated into the rest of the formula it was fine.

Thanks again.