| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
| how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
| How do I make cell contents "blink" in Excel? | Excel Discussion (Misc queries) | |||
| get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
Linear Mode
