Appreciate any help on this guys: I have the following formula =IFERROR(INDIRECT("'January 2017'!E8"),"") and it does what I need...except when I insert a row above E8 on this spreadsheet, I need E8 to become E9 in the formula. The E8 of the formula is hardcoded. Can I get around this?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IFERROR(INDIRECT("'January 2017'!E8"),"")
0
Answers
0
Give the cell that is currently E8 a Name and then reference that name using the INDIRECT() function and it should work becuase then you are not referencing a specific location.
0
Alternatively =IFERROR(INDIRECT("'January 2017'!"&E8),"")