Combine 2 cells to match a predefined name?
If it is in the same workbook you could try this:
=INDIRECT("Inc."&A1)
You might need to put the sheet name before the Inc.
INDIRECT only works with open files.
Hope this helps.
Pete
On Oct 23, 12:08*am, tgardiner
wrote:
I have different columns named 2007 (A1), 2008 (B1), 2009 (C1), etc. *I have
a cell on a different sheet that I have named "Inc.2007". *Is there a way to
combine "Inc."&A1 and have it return the value in the named cell?
As I do it now, I put ="Inc."&A1, and it returns the value "Inc.2007",
instead of the value that is named "Inc.2007'. *Is there any way to make this
work?
|