Getting INDIRECT/ADDRESS to return results from another Worksheet?

  • Thread starter Thread starter Vik Rubenfeld
  • Start date Start date
V

Vik Rubenfeld

I've got this formula, which currently works correctly:

=INDIRECT(ADDRESS(41, $S49))

Let's say this formula is on a sheet called "Sheet 1". I want to take
the contents of the cell located at INDIRECT(ADDRESS(41, $S49)), and
move those contents to the same cell & column location in another sheet,
called, let's say, "Sheet 2", in the same workbook. Everything else on
Sheet 1 will stay the same. How can I update this formula on "Sheet 1"
so that it will return the data from "Sheet 2"? Thanks in advance to all
for any info.

-Vik
 
Try this:

=INDIRECT(ADDRESS(41, $S49,,,"sheet2"))

Watch those commas !
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I've got this formula, which currently works correctly:

=INDIRECT(ADDRESS(41, $S49))

Let's say this formula is on a sheet called "Sheet 1". I want to take
the contents of the cell located at INDIRECT(ADDRESS(41, $S49)), and
move those contents to the same cell & column location in another sheet,
called, let's say, "Sheet 2", in the same workbook. Everything else on
Sheet 1 will stay the same. How can I update this formula on "Sheet 1"
so that it will return the data from "Sheet 2"? Thanks in advance to all
for any info.

-Vik
 
Vik Rubenfeld said:
I've got this formula, which currently works correctly:

=INDIRECT(ADDRESS(41, $S49))

. . . How can I update this formula on "Sheet 1"
so that it will return the data from "Sheet 2"? . . .
Click to expand...

An alternative if the worksheet and row would be constants,

=OFFSET('Sheet 2'!$A$41,0,$S49-1)
 
Back
Top