Hi,

Thanks very much, I think that will be ok. I will try some of the other
tricks you suggested a swell.

Kind regards,
Izo

"JLatham" wrote:

Sorry, you cannot display the values from multiple cells within a single
cell. It just doesn't work that way.

Test it yourself, instead of using the INDIRECT() in a cell, just (for
testing) enter the formula normally as:
='33'!A5
and then try something like
='33'!A5:A7
Second attempt will not give you the results you expect.

But =SUM(33!A5:A7) will work fine, since that's a legitimate place to use a
range reference.

You really need the entire indirect in one cell. A37 probably should look
more like
="Sheet1" & "!A5") so you can easily change the sheet name, or even
="Sheet1" & "!A5:A7" for special cases where a range is permitted, as in:
=sum(Indirect(A37))
would be the same as
=SUM('Sheet1'!A5:A7) which is entirely ok to use, but just plain
=Sheet1!A5:A7 is not going to give you the answer you want.




"Izo" wrote:


Hi,

A37 contains the text "33" which is the name of the worksheet I'm trying to
reference. So =INDIRECT(A37 & "!A5") is getting A5 from worksheet 33. I'd
like to be able to get a range in worksheet 33 and display it in my cell, if
that's even possible.

Thanks for your help,
Izo

"JLatham" wrote:

Question is what is in A37?
If it is a formula, need the formula and its result (what is displayed in
the cell).

When I said "if a cell range is appropriate" I meant at times such as within
a VLOOKUP() formula. As you've used it, I would expect an error: you're
trying to reference several cells within just a single cell and that won't
work.

"Izo" wrote: