Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting values from names by reference
I am looking to get a value from a name created by concatination. For Example
I have a Column with January in B2 and a Row with Income in A4. I have a named reference of Income with a scope of January. I also have the other months as well. I want to create the reference [CONCATENATE(B$2,"!",$A4)] and get the value of that reference in the cell. If I use indirect, I get a reference error. Anyone have any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference other worksheets via variable names | Excel Worksheet Functions | |||
Fixing sheet names is a 3D reference | New Users to Excel | |||
worksheet names in drop down list for reference | Excel Discussion (Misc queries) | |||
reference to range names | Excel Discussion (Misc queries) | |||
reference to sheets without using sheet names | Excel Worksheet Functions |