Examples
=ADDRESS(3, 5) creates the address $E$3.
=ADDRESS(3, 5, 2) creates the address E$3.
=ADDRESS(3, 5, 3) creates the address $E3.
=ADDRESS(3, 5, 4) creates the address E3.
=ADDRESS(3, 3,,,"Sheet 2::Table 1") creates the address Sheet 2::Table 1::$C$3.