I have given the cell A1 a name (ie smith). In another cell I am trying to
use the address function to tell me what that cell has been named. If I type
in =address(1,1) it returns $a$1. I want it to return smith. Does anyone know
how to do this?