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!
|