Seting up an Indirect Formula

  • Thread starter Trying to set up Indirect fomula
  • Start date
T

Trying to set up Indirect fomula

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

PCLIVE

I'm not sure I understand what the formula is supposed to do.
Assuming that "Exp Crit" is a sheet name and cell A2 on that sheet contains
the name of a sheet as well, then the following formula will return the
contents of cell A1 on a worksheet determined by the contents of cell A2 on
the worksheet "Exp Crit". This may or may not get you closer to the formula
you're looking for.

=INDIRECT("'"&('Exp Crit'!$A$2) & "'!A1")

The "Row" section of your formula I was unsure of.
ROW(INDIRECT($A$2)) + ROW(B2) - ROW($A$2) - 4)

I wasn't sure what it was supposed to be doing.

The function, "Row($A$2)" I believe will always return "2". So why not use
"-2" without using the "Row" function?


Sorry I couldn't be of more help, if any.
Paul

"Trying to set up Indirect fomula" <Trying to set up Indirect
[email protected]> wrote in message
news:[email protected]...
 
Top