Thread: Formulas within Cell References
View Single Post
  #3   Report Post  
jhockstr jhockstr is offline
Junior Member
  
Posts: 4
Default
I tried to do that but it will not work in the actual cell reference. I'm stumped.



Quote:
Originally Posted by humejap
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
Reply With QuoteReply With Quote