Incorporating Worksheet name as variable from ref cell (list) in in a formula

R

Roger D

Hi -- 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
 

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

Top