Use the value of a cell within a reference to another workbook?
 

I am trying to use the text value of a cell within a reference to a cell on a
different worksheet.

The formula that directly accesses the cell on the outside worksheet is

=ILX|Q!'msft,last'

The value of cell B3 in the current workbook is msft but when I use it...

ILX|Q!'B3,last'

it doesn't work. I'm sure it is something simple, but any help much
appreciated!!

Use the value of a cell within a reference to another workbook?
 

You'll need to use indirect for this. I don't quite understand why

=ILX|Q!'msft,last'

works, but if you have msft in B3, you'll need to change it to

=indirect("ILX|Q!'"&b3&",last'")


"MR" wrote:

I am trying to use the text value of a cell within a reference to a cell on a
different worksheet.

The formula that directly accesses the cell on the outside worksheet is

=ILX|Q!'msft,last'

The value of cell B3 in the current workbook is msft but when I use it...

ILX|Q!'B3,last'

it doesn't work. I'm sure it is something simple, but any help much
appreciated!!