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