Thread: "indirect" formula reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ORLANDO VAZQUEZ[_2_] ORLANDO VAZQUEZ[_2_] is offline
external usenet poster
  
Posts: 43
Default "indirect" formula reference
Hi,

How can I re-write this formula so that when I copy it down 1 row the
ref_text portion !d483 changes to !d484 ?

=+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483")

Please help.

Thanks,
Orlando
Reply With QuoteReply With Quote