Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine 2 cells to match a predefined name?
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
Combine two predefined borders | Excel Discussion (Misc queries) | |||
Excel: Combine and match two data | Excel Discussion (Misc queries) | |||
Combine index match and sumproduct | Excel Discussion (Misc queries) | |||
How do I combine and match data from 2 sheets | Excel Discussion (Misc queries) |