Posted to microsoft.public.excel.worksheet.functions

Confused_Euffy Confused_Euffy is offline

external usenet poster

Posts: 1

indirect formula

I am trying to use the indirect formula to look at a particular cell on
another worksheet. My formula is - =INDIRECT('Tracking Sheet'!A4). The
result i am getting is #REF. I am inserting new rows in the tracking sheet
but i would like A4 to be the constant.

Hope this makes sense. Can somebody help me please?

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
indirect formula	sanmos	Excel Worksheet Functions	2	January 11th 07 10:05 PM
indirect formula help	ivory_kitten	Excel Worksheet Functions	10	September 19th 06 04:44 AM
Indirect Formula	lmullenjr	Excel Discussion (Misc queries)	2	May 10th 06 03:19 PM
indirect formula	Manos	Excel Worksheet Functions	0	February 16th 05 01:17 PM

All times are GMT +1. The time now is 05:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us