Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
in A2 in Financials worksheet I have the following formula
=INDIRECT("'Merchandise'!"&ADDRESS(70,(COLUMN()))) . THIS DIRECTS ME TO $A$470 on The merchandise worksheet IN A18, A34, A50 REPEATING in Financials worksheet I need to have a formula that takes me to $A$150 $A$230 $A$310 CAN I MODIFY THE ABOVE FORMULA TO INCREASE IN AMOUNTS OF 80 OR DO i START AGAIN Help and thanks for your time Stew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
On Sun, 7 Sep 2008 07:33:00 -0700, stew
wrote: in A2 in Financials worksheet I have the following formula =INDIRECT("'Merchandise'!"&ADDRESS(70,(COLUMN())) ). THIS DIRECTS ME TO $A$470 on The merchandise worksheet IN A18, A34, A50 REPEATING in Financials worksheet I need to have a formula that takes me to $A$150 $A$230 $A$310 CAN I MODIFY THE ABOVE FORMULA TO INCREASE IN AMOUNTS OF 80 OR DO i START AGAIN Help and thanks for your time Stew Assuming the $A$470 is just a mistype for $A$70. Replace the 70 in your formula with 60+5*ROW() Then, when you copy the formula to the mentioned rows, the references will be as stated above. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
Yes it was a MisType and yes it works
Thank you for your time Stewart "Lars-Ã…ke Aspelin" wrote: On Sun, 7 Sep 2008 07:33:00 -0700, stew wrote: in A2 in Financials worksheet I have the following formula =INDIRECT("'Merchandise'!"&ADDRESS(70,(COLUMN())) ). THIS DIRECTS ME TO $A$470 on The merchandise worksheet IN A18, A34, A50 REPEATING in Financials worksheet I need to have a formula that takes me to $A$150 $A$230 $A$310 CAN I MODIFY THE ABOVE FORMULA TO INCREASE IN AMOUNTS OF 80 OR DO i START AGAIN Help and thanks for your time Stew Assuming the $A$470 is just a mistype for $A$70. Replace the 70 in your formula with 60+5*ROW() Then, when you copy the formula to the mentioned rows, the references will be as stated above. Hope this helps / Lars-Ã…ke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on a Formula | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Question regarding formula | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |