LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide formula skateblade Excel Worksheet Functions 10 October 15th 05 08:36 PM
Indirect used in an array formula Werner Rohrmoser Excel Worksheet Functions 3 July 23rd 05 04:03 PM
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Indirect references in a linked formula Markshnier Excel Worksheet Functions 0 November 15th 04 03:36 AM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"