Ah, I see the issue, the documentation is incorrect. There are five fields, not just four, which is the problem you are seeing.
It should be something like =ADDRESS(1,1,1,1,"Sheet2")
Ah, I see the issue, the documentation is incorrect. There are five fields, not just four, which is the problem you are seeing.
It should be something like =ADDRESS( 1,1,1,1, "Sheet2" )