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.






jhockstr Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395435