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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to external tab referenced by local cell
Hi
At first, your formula is a range reference, and it doesn't have any meaning by itself. You must use it as a source for some another function, with returns a real value (SUM, COUNT, etc.). So, you need something like =SUM(INDIRECT("'Summary'!$1:$" & SUM(8,H5)) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Iwanow" wrote in message oups.com... 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 |
Reply |
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 |