| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with indirect
What's in AD65? Is it a number?
What's in the cell (G<11+whateverisinad65) And it's probably best to post the formulas you actually used in the worksheet instead of retyping them in the message. Maybe you made a mistake in the formulas you posted--for instance, the second one isn't correct. Maybe the same thing happened in the worksheet??? Brad wrote: On one particular sheet I'm having problem getting indirect to work =indirect("G"&11+ad65) will give me a value error - However =indirect("G"&text(11+ad65,"##)) - will give me the correct answer In the same workbook - the first method of indirect works just fine. Does anyone know what is going on with this? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| Indirect and Sumif Syntax Problems | Excel Discussion (Misc queries) | |||
| Problems with PULL function, INDIRECT.EXT and so forth | Excel Worksheet Functions | |||
| Is "INDIRECT" the cause of these problems? | Excel Discussion (Misc queries) | |||
Threaded Mode
