| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create cell reference in formula
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create cell reference in formula
=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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create cell reference in formula
Try this:
=IF(ISERROR(CELL("address",INDIRECT("'"& A3 & "'!k37"))),"",INDIRECT("'" & A3 &"'!k37")) HTH, Paul "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create cell reference in formula
=IF(ISERROR(CELL("address",INDIRECT("'" & A3 & "'!k37"))),"
",INDIRECT("'" & A3 & "'!k37")) -- Regards, Tom Ogilvy "J.W. Aldridge" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create cell reference in formula
It's not necessary to multipost.
"J.W. Aldridge" wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create cell reference in formula
,,,,THANX EVERYONE! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL - FORMULA TO CREATE A TAB REFERENCE | Excel Discussion (Misc queries) | |||
| Using a cell in formula to create a reference | Excel Worksheet Functions | |||
| Using a cell in formula to create a reference | Excel Worksheet Functions | |||
| create reference formula that looks through all sheets for matchin | Excel Worksheet Functions | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
Hybrid Mode
