Need Formulas within Cell References

[jhockstr]

I tried to do that but it will not work in the actual cell reference.
I'm stumped.



humejap Wrote:
> Have you tried the formula
>
> =Concatenate("$J$",H1)
>
>
> --
> humejap
> ------------------------------------------------------------------------
> humejap's Profile:
> http://www.excelforum.com/member.php...fo&userid=5506
> View this thread:
> http://www.excelforum.com/showthread...hreadid=395098


--
jhockstr

[Bryan Hessey]

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 tried to do that but it will not work in the actual cell reference.
I'm stumped.



humejap Wrote:
> Have you tried the formula
>
> =Concatenate("$J$",H1)
>
>
> --
> humejap
> ------------------------------------------------------------------------
> humejap's Profile:
> http://www.excelforum.com/member.php...fo&userid=5506
> View this thread:
> http://www.excelforum.com/showthread...hreadid=395098


--
jhockstr