I tried to do that but it will not work in the actual cell reference I'm stumped.
J jhockstr Aug 12, 2005 #1 I tried to do that but it will not work in the actual cell reference I'm stumped.
B Bryan Hessey Aug 13, 2005 #2 I missed the original question, but whilst =Concatenate("$J$",H1) will join to give $J$ joined to the contents of H1 you might need =Indirect("$J$"&H1) if you want to pick up the value in the cell indicated by the concat statement.
I missed the original question, but whilst =Concatenate("$J$",H1) will join to give $J$ joined to the contents of H1 you might need =Indirect("$J$"&H1) if you want to pick up the value in the cell indicated by the concat statement.
