Thread: Reference a cell containing a Reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vito Vito is offline
external usenet poster
  
Posts: 1
Default Reference a cell containing a Reference

Are you sure the formula as you wrote it here is working?

I get error messages.


but basically, the Indirect() function should replace what you
reference to a specific cell..


e.g. =Indirect("AK"&A1) would return value in AK533 if A1 houses 533.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558885

Reply With QuoteReply With Quote