Posted to microsoft.public.excel.misc

F. Lawrence Kulchar F. Lawrence Kulchar is offline

external usenet poster

Posts: 124

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use indirect function?	Eric	Excel Discussion (Misc queries)	2	February 29th 08 12:47 AM
How to use indirect function?	Eric	Excel Discussion (Misc queries)	2	January 30th 07 03:57 PM
INDIRECT function inside AND function	Biff	Excel Worksheet Functions	3	September 23rd 06 07:20 PM
Need help on Indirect function	Naveen	Excel Discussion (Misc queries)	3	August 11th 06 06:45 PM
Indirect function ?	Carlos Antenna	Excel Worksheet Functions	5	July 4th 06 02:29 AM

All times are GMT +1. The time now is 05:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us