INDIRECT function
 

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

INDIRECT function
 

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?

--
Regards
Roger Govier

"F. Lawrence Kulchar" wrote in
message ...
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

INDIRECT function
 

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

"F. Lawrence Kulchar" wrote:

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

INDIRECT function
 

There was something wrong...I closed the spreadsheet and reopened it without
incident. Thanks,
FLKulchar
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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?

--
Regards
Roger Govier

"F. Lawrence Kulchar" wrote
in message ...
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

INDIRECT function
 

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
"Mike H" wrote in message
...
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

"F. Lawrence Kulchar" wrote:

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