View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default 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