| 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 |
| 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 | |||
Threaded Mode
