View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FLKulchar FLKulchar is offline
external usenet poster
 
Posts: 80
Default 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