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!

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
wrote in message
...
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!