| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect formula
Ah i see now, thank you.
"Dave Peterson" wrote: You always want to point at A4 of "Tracking Sheet"? If yes, try: =INDIRECT("'Tracking Sheet'!A4") When you used: =INDIRECT('Tracking Sheet'!A4) excel was looking for something that looked like an address in A4 of that tracking sheet. And then tried to go get the value in the cell that 'Tracking Sheet'!A4 pointed to. Confused_Euffy wrote: 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? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| indirect formula | Excel Worksheet Functions | |||
| indirect formula help | Excel Worksheet Functions | |||
| Indirect Formula | Excel Discussion (Misc queries) | |||
| indirect formula | Excel Worksheet Functions | |||
![Confused_Euffy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
