INDIRECT with raltive name(s)

  • Thread starter Werner Rohrmoser
  • Start date
W

Werner Rohrmoser

Hi,

Problem: When I use a relative name in the INDIRECT function I do net
get the right result.

Detail:
To transfer data from one to another sheet I have created relative
names.
On the source sheet the production machines are listed vertically and
the
time periods are listed horizontally. The table contains production
capacities
over the time.
The relative names are like "Source!B$77", so I get the value of
"Source!D77", when I use the rel. name in "Destination!D15" for
example. (same time period)
On the destination sheet I have listed the relative names as text
constants
in Col A, so it would be fine to use it in an INDIRECT function in
order to copy
the formulas down and to avoid inconsistancies
But I always get only the value of "Source!A$77", no matter what's the
cell on "Destination"
I entered the formula.

Regards
Werner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT, relative name as argument 8
Referencing formula using Indirect 4
Indirect reference 2
Indirect function and relative references 4
INDIRECT with Sheet Level Defined Name 2
Help with Address(), Indirect(), Offset 2
Search tab using indirect for number of times in a range 3
Referencing Workbook Name in Formula 4

Top