In answer to my own post...

I was trying to reference a cell containing a formula.

Instead, paste special, values, then can be successfully referenced and used in ADDRESS function.