{"id":4637,"date":"2021-11-11T08:00:45","date_gmt":"2021-11-11T08:00:45","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&p=4637"},"modified":"2021-11-11T08:04:08","modified_gmt":"2021-11-11T08:04:08","slug":"using-absolute-cell-reference-with-indirect","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/using-absolute-cell-reference-with-indirect\/14216.html","title":{"rendered":"Using Absolute Cell Reference With INDIRECT"},"content":{"rendered":"

Hi
\nCan I get Absolute Cell reference with INDIRECT function? Presently I have a 2 worksheets named “April 2011” and “Summary”. I want to access a value of cell in “April 2011” worksheet in “Summary” worksheet. So I used the following formula.<\/p>\n

=INDIRECT(“‘”&A5;&”‘!G$5”)<\/p>\n

where cell “A5” contains worksheet name (“April 2011”) and G5 cell in “April 2011” worksheet contains the value to be displayed. Now, I have inserted another row in “April 2011” worksheet and the G5 cell becomes G6. But the formula remains the same ( =INDIRECT(“‘”&A5;&”‘!G$5”)) and displays wrong value. Is there any way where I can increment or decrement the cell reference while adding or removing rows. Sorry for the Bad english.<\/p>\n

What i was intended is when i insert a ROW in “April 2011” worksheet, the INDIRECT formula in “Summary” worksheet also change. i.e, If after inserting a row, G5 cell changed to G6, then i want the INDIRECT formula also change to =INDIRECT(“‘”&A5;&”‘!G$6”), automatically. It is not happening with current worksheet. I am using MS Excel 2007<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-4637","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/4637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=4637"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=4637"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=4637"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=4637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}