View Single Post
  #1   Report Post  
Trying to set up Indirect fomula
 
Posts: n/a
Default Seting up an Indirect Formula

I need to set up a formula where "Rates" pulls information from "Exp Crit"
The Problem is:
1 Exp Crit is not always the same size

I thought to set up a Start location refering to a set cell on "exp crit"
but can not get it to work using =INDIRECT("'Exp Crit' !A2") As a Start point
there for if it moved I would only have to modify the start location to its
new cell using (Slashes Reprisent cells)
Start Location / A2
A / B / C / D / E

=INDIRECT("Exp Crit!" & A$2 & (ROW(INDIRECT($A$2)) + ROW(B2) - ROW($A$2) - 4))

But can not get it to pul anything but a #REF!