cell = sheet ref in formula

[Roger]

Hi -- Reposting because the subject wasn't clear before
and didn't have my email address.

I need to pull results from multiple cells in
multiple spreadsheets. I would like to put the sheet name
in a cell (e.g. top of a column), then refer to it in the
formula. I have tried, but so far get error. So, I know
that:
=+Ref_Sheet!B2
works for returning results from a spreadsheet
named 'Ref_Sheet'

However:
=+'J1'!B2
with the contents of cell J1 = Ref_Sheet returns #REF!
error.

So, is there some way I can write the expression to read a
cell (in this case J1) as a spreadsheet name?

Thanks in advance for any assistance. Roger
..

 

[JE McGimpsey]

First, lose the "+", it's not necessary. One way:

=INDIRECT(J1 & "!B2")

 

[Guest]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Lady Layla]

For a fee I am sure --- Please STOP advertising here

If you want to truly help, help!


: I am from the MS Excel support department at
http://www.enterpriseprojectconsulting.com and we would be happy to assist you
in resolving your issue.
:
: Thank you,
:
: Enterprise Project Consulting
:

 

[Vasant Nanavati]

Also, it's very cheesy to give the (no doubt intentional) impression that
you are associated with Microsoft.

--

Vasant

I am from the MS Excel support department at

http://www.enterpriseprojectconsulting.com and we would be happy to assist
you in resolving your issue.