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

G

Guest

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?
 

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

Similar Threads

concatenate contents of cells whose contents resemble cell referem 3
evaluate a concatenate expression 3
setting cell values based on a 3rd cell 4
How to use a cell value as the ref argument in CELL"contents" form 3
How do I use the text content of a cell as a worksheet reference? 9
Need Help 4
how do I create a cell reference from ADDRESS function return? 3
Countif contains a word in a reference cell 3

Top