Reference to cell with external spreadsheet

  • Thread starter Thread starter B Lane
  • Start date Start date
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
 
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
 
Back
Top