| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use data in cell as a formula for another cell
Hi
I have in cell a1 = 2007 and a2 = 2008 and then I wish to input the results of a lookup to another file which uses the data from ColA eg COUNTIF([2008_04_apr_Creation.xls]Sheet4!$Y:$Y,"#N/A") I need to change 2008 to 2007. Thanks for any help, or ideas, Noel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use data in cell as a formula for another cell
Have a look at the "indirect" function in help.
COUNTIF(INDIRECT("[" & A1 & "_04_apr_Creation.xls]Sheet4!$Y:$Y"),"#N/ A") hth Carlo NoelH wrote: Hi I have in cell a1 = 2007 and a2 = 2008 and then I wish to input the results of a lookup to another file which uses the data from ColA eg COUNTIF([2008_04_apr_Creation.xls]Sheet4!$Y:$Y,"#N/A") I need to change 2008 to 2007. Thanks for any help, or ideas, Noel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use data in cell as a formula for another cell
The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. NoelH wrote: Hi I have in cell a1 = 2007 and a2 = 2008 and then I wish to input the results of a lookup to another file which uses the data from ColA eg COUNTIF([2008_04_apr_Creation.xls]Sheet4!$Y:$Y,"#N/A") I need to change 2008 to 2007. Thanks for any help, or ideas, Noel -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use data in cell as a formula for another cell
ps. =countif() won't work with a closed workbook, either.
But there are workarounds for that, too--using =sumproduct() is one alternative. NoelH wrote: Hi I have in cell a1 = 2007 and a2 = 2008 and then I wish to input the results of a lookup to another file which uses the data from ColA eg COUNTIF([2008_04_apr_Creation.xls]Sheet4!$Y:$Y,"#N/A") I need to change 2008 to 2007. Thanks for any help, or ideas, Noel -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to lookup data in cell NEXT to another cell | Excel Worksheet Functions | |||
| how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
