Reference to cell with external spreadsheet

B

B Lane

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
 
L

larskemail

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
Click to expand...

If you long range name is in cell A1, try this formula:

=SUM(INDIRECT(A1))

Hope this helps / Lars-Åke
 

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

Lookup returning wrong results 0
Vlookup referring to External Workbook or Spreadsheet 1
Using Value of a Cell in the Range Reference in VLOOKUP 1
Retain font/cell color on lookup/copy 3
Using Lookup Function based on Font Color 1
Counting Results of Formulas 1
Offset Reference Cell 1
References to external workbooks 4

Top