Formula reference to a cell instead of inputing

J

J.W. Aldridge

Hi.

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

Any advice?

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

Thanx.
 
D

Dave Peterson

try:

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

Neat way to check to see if a worksheet is there, huh?
 
Top