Formula reference to a cell instead of inputing

  • 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
name itself.

Any advice?

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

Thanx.
 
try:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create cell reference in formula 5
Reference Cell Altering Formulas 1
Formula change from cell reference to count 3
COUNTIF + ADDRESS Issue 1
Cell Value as Named Range Reference 1
Building closed workbook file path within an Index Function 6
Sumproduct when data column changes 1
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2

Back
Top