INDIRECT function

[F. Lawrence Kulchar]

In cell J5, I have:

=INDIRECT("C"&C5)...

so, it returns the value of cell C529 (in this case, I have a 529 in cell
C5), which is 82.53.

NOW, IN CELL, J10, I HAVE:

=J5........and I get a "0" returned (???)

How can I get cell J5 to read, also, 82.53???? via the J5 route?

Thanks,

FLKulchar

 

[Roger Govier]

Hi

It works fine for me.
what are the ... after your formula, are you saying that there is something
else within the formula in J5?

 

[Mike H]

A puzzler!!

What do you get if you address C529 directly? Is that all you have in J10 or
is it part of a larger formula?

Mike

 

[FLKulchar]

There was something wrong...I closed the spreadsheet and reopened it without
incident. Thanks,
FLKulchar

 

[FLKulchar]

There was something wrong -- I cloded the spreadsheet and reopened it
without incident. All is okay now; to be honest, at some time, inbetween, I
was working with a "circular reference". I believe that had something to do
with the dilemma.

Thanks,
FLKulchar