Indirect formula

  • Thread starter Thread starter Samir
  • Start date Start date
S

Samir

Hello everyone,

I need to write a formula to obtain values from another
work book. At this moment the formula looks like this:

=[My Book.xls]Test'!B6

The above formula is in another workbook in sheet "My
Sheet". I want to write the formula so the column
reference B is taken from A1 in sheet "My Sheet". This is
because each week the column letter changes for the
report. Any help appreciated.

Regards

Samir
 
Hi
the following works ONLY if the other workbook is open!:
=INDIRECT("'[My Book.xls]Test'!" & A1 & "6")
 
Frank,

Thanks. This works.

Regards

Samir
-----Original Message-----
Hi
the following works ONLY if the other workbook is open!:
=INDIRECT("'[My Book.xls]Test'!" & A1 & "6")

--
Regards
Frank Kabel
Frankfurt, Germany

Hello everyone,

I need to write a formula to obtain values from another
work book. At this moment the formula looks like this:

=[My Book.xls]Test'!B6

The above formula is in another workbook in sheet "My
Sheet". I want to write the formula so the column
reference B is taken from A1 in sheet "My Sheet". This is
because each week the column letter changes for the
report. Any help appreciated.

Regards

Samir
Click to expand...
.
Click to expand...
 
Back
Top