| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
There are quite a few ways. Here's one:
=INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Try the below
=+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
That works fantastically. Can we also make the column changeable too ?
"ORLANDO VAZQUEZ" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Can we make the column changeable too ?
"Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Can we make the column changeable too ?
"Jacob Skaria" wrote: Try the below =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
=INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1)))
HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Hi Bernie,
How can I make this formula adjust for column movement too ? I tried to do the same as you did with Row by using COL but it doesn't work that way. Thanks for your help. Orlando "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Jacob,
That worked great. Can I make the column likewise changeable so that if I move it down one and right one it also changes column ref ? "Jacob Skaria" wrote: Try the below =+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d" & ROW(A483)) If this post helps click Yes --------------- Jacob Skaria "ORLANDO VAZQUEZ" wrote: 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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Worked great! Thank you.
"Bernie Deitrick" wrote: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1))) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Bernie,
Is there a way to shorten the formula below. All that is changing one digit in the indirect ref text. i.e., AH6 becomes AH7 .....AH7 becomes AH8...and so on. Orlando =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$7&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$8&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$9&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$10&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$11&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) "Bernie Deitrick" wrote: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1))) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"indirect" formula reference
Orlando,
AFAIK, you cannot use INDIRECT with 3 D ranges, so there is no way to shorten this. HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Bernie, Is there a way to shorten the formula below. All that is changing one digit in the indirect ref text. i.e., AH6 becomes AH7 .....AH7 becomes AH8...and so on. Orlando =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$7&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$8&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$9&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$10&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) +INDIRECT("'"&'ACCOUNT MASTER'!$AH$11&"'!" & ADDRESS(ROW(D483),COLUMN(D483))) "Bernie Deitrick" wrote: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!" & ADDRESS(Row(A483),COLUMN(D1))) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... Can we make the column changeable too ? "Bernie Deitrick" wrote: There are quite a few ways. Here's one: =INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483)) HTH, Bernie MS Excel MVP "ORLANDO VAZQUEZ" wrote in message ... 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 |
| Reply |
| 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)
Linear Mode
