| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"indirect" formula reference
Hi,
How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483") Please help. Thanks, Orlando |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula like "=INDIRECT("X"&$K$(ROW())" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Converting a text form of "=Sheet2!A1" into a reference formula | Excel Discussion (Misc queries) | |||
| To have this formula work with numbers & Text ='T(INDIRECT("'"& | Excel Worksheet Functions | |||
| Formula 'mis' calculate when reference cell contains a "0" | Excel Discussion (Misc queries) | |||
![ORLANDO VAZQUEZ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
