Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Indirect used in an array formula | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Indirect references in a linked formula | Excel Worksheet Functions |