=IF(ISERROR(CELL("address",INDIRECT("'"&A3&"'!k37" ))),"",INDIRECT("'"&A3&"'!
k37"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"J.W. Aldridge" wrote in message
ups.com...
Hi.

I need the following formula to point to cell (I.e. A3) for the name
(John Doe) instead of me putting the whole name itself.

Any advice?

=IF(ISERROR(CELL("address",INDIRECT("'John Doe'!k37"))),"
",INDIRECT("'John Doe'!k37"))



Thanx