Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference to cell with external spreadsheet
I have a lookup function with a very long range name which referrs to another
spreadsheet. I would like to make a cell with the text of the range and just refer to the cell in the lookup function. Is this possible? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference to cell with external spreadsheet
On 19 Dec, 20:43, B Lane <B wrote:
I have a lookup function with a very long range name which referrs to another spreadsheet. I would like to make a cell with the text of the range and just refer to the cell in the lookup function. Is this possible? Thank you If you long range name is in cell A1, try this formula: =SUM(INDIRECT(A1)) Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell value to build external reference | Excel Discussion (Misc queries) | |||
cell data for external reference | Excel Worksheet Functions | |||
External reference to spreadsheet names (tabs) help needed. | Excel Discussion (Misc queries) | |||
Using cell value to reference external worksheet? | Excel Worksheet Functions | |||
dynamic external cell reference | Excel Worksheet Functions |