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
|