Using cell content to access another worksheet in same workbook

S

ScubaBum

This should be simple but the functions that would appear to be the answer
don't work. I have a worksheet name that is contained in column one of
another worksheet row. I want to use that cell content to access the named
worksheet and populate a cell in the same row of the first worksheet. For
example, in worksheet A the content of cell A2 = B. I want to populate cell
B2 in worksheet A with the contents of cell B200 in worksheet B (the content
of A!A2). Then for other contents of column A of sheet A, Bx will be
populated with the contents of B200 of the sheet named in Ax where x is the
row number. The INDIRECT function does not appear to work in this case but
maybe I am formatting it wrong.

Thanks
 
B

Bob Phillips

=INDIRECT("'"&A2&"'!B200")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
S

ScubaBum

Bob,

That was quick and it worked. Mind explaining how you constructed this answer?
IE, what does each part of the function mean, particularly the quotes,
ampersands, etc?

Thanks

Bob said:
=INDIRECT("'"&A2&"'!B200")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
This should be simple but the functions that would appear to be the answer
don't work. I have a worksheet name that is contained in column one of
Click to expand...
[quoted text clipped - 8 lines]
Thanks
Click to expand...
Click to expand...
 
B

BRABUS

is there a function that works in a similar way but can reference files
that are not open?

Thanks
 
Top