Using Address Function to create an address referencing the entire column

Hi Guys,

I'm trying to create an address that references an entire column using the ADDRESS function. For example spreadsheetName!B:B.
So the formula would look something like ADDRESS(___,2,4,1,"spreadsheetName"), any ideas?

Regards