Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to external tab referenced by local cell
Hello everybody!
I'm trying to create a formula that gets value from a cell located on some other sheet. The issue is as follows: exact location of that "foreign" cell depends on value of some other cell located on the localtab. Frankly speaking, the formula should look like that: 'Summary'!$1$(8 + H5) and: - "Summary" is name of the foreign tab - "1" indicates the first column in tab "Summary" - "H5" is a cell in _local_ tab - value (8 + H5) should be a row number in the "Summary" tab. Unfortunately, Excel doesn't accept that formula. Any ideas how to fix it? Thank you in advance for your help. -- Regards, Iwanow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Go to cell referenced in a formula | Excel Discussion (Misc queries) | |||
Excel formula timestamp for a data entry of a referenced cell | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Click in cell w/ formula and get colors in referenced cells | Excel Discussion (Misc queries) | |||
function CELL() to return the formula in the referenced cell | Excel Worksheet Functions |