View Single Post
  #3   Report Post  
alex
 
Posts: n/a
Default

thanks a lot.

"Excel_Geek" wrote:


You can used =INDIRECT(A1&"total"), where "A1" is the reference to the
cell with the "aa" in it and "total" is the back half of the name of
the named reference cell.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399064