INDIRECT reference to another worksheet in same workbook


J

Johan

Sorry for a dumb question but I cannot get this right.

I have a workbook with multiple worksheets, lets say the sheet names are
Summary, Jan, Feb etc. In sheet 'Summary' in cell A1 I have the name of one
of these sheets, let's say A1 =Jan.

In cell A3 (of 'Summary') i want the contents of cell B2 of sheet Jan
displayed.

I have the following formula in cell A3 (of 'Summary') =INDIRECT(A1&"!B2")
but I get a REF error back.

Please help
 
Ad

Advertisements

M

Max

Data inconsistency is the usual culprit. Eg there could be an extra trailing
white space in the sheetname entered in B2 (not readily visible) which is
throwing the match off

Try this rendition in A3: =INDIRECT("'"&TRIM(A1)&"'!B2")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
 
Ad

Advertisements

J

Johan

Thanks for the response. I was trying to simplify my problem here. I now
realise that my problem is that I actually have a vlookup formula in A1 (and
not simply a directly the sheet name). This is probably causing my problem
 

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