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?