create cell reference in formula

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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 whole name itself.

Any advice?

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



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

--
HTH

Bob Phillips

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

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

HTH,
Paul
 
=IF(ISERROR(CELL("address",INDIRECT("'" & A3 & "'!k37"))),"
",INDIRECT("'" & A3 & "'!k37"))
 
It's not necessary to multipost.

J.W. Aldridge said:
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
Click to expand...
 
Back
Top