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

[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

 

[Frank Kabel]

Hi
have a look at the INDIRECT function in the Excel help

 

[Guest]

Thanks for the tip !

-----Original Message-----
Hi
have a look at the INDIRECT function in the Excel help

--
Regards
Frank Kabel
Frankfurt, Germany



.