ExcelBanter - nested Cell("contents", w/ cell contents reference)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - nested Cell("contents", w/ cell contents reference) (https://www.excelbanter.com/excel-worksheet-functions/162720-nested-cell-contents-w-cell-contents-reference.html)

nested Cell("contents", w/ cell contents reference)

I'm trying to reference the cell contents of a cell in a different worksheet
by using the cell reference contained in a cell of the current sheet

i.e. ThisWorksheet cell B1 evaluates to a value "F159"

=CELL("contents",'Other Sheet'!F159) is what I'm after

somehow I want to get that using the ThisWorksheet B1 reference?

=CELL("contents",'Other Sheet'! & cell("contents",b1))?????

how do I construct or concatenate the appropriate references to meet my needs?

--
Jim

nested Cell("contents", w/ cell contents reference)

Try using the INDIRECT function:

=INDIRECT("'Other Sheet'!"&B1)

HTH,
Elkar

"JASelep" wrote:

I'm trying to reference the cell contents of a cell in a different worksheet
by using the cell reference contained in a cell of the current sheet

i.e. ThisWorksheet cell B1 evaluates to a value "F159"

=CELL("contents",'Other Sheet'!F159) is what I'm after

somehow I want to get that using the ThisWorksheet B1 reference?

=CELL("contents",'Other Sheet'! & cell("contents",b1))?????

how do I construct or concatenate the appropriate references to meet my needs?

--
Jim